Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 To: Khurram Tahir
  Where is Khurram Tahir?
 Karachi
 Pakistan
 Khurram Tahir
 Tags
Subject: RE: Sql Select Cursor to be use in Select
Thread ID: 209515 Message ID: 209518 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Monday, December 29, 2008 11:38:07 AM         
   


> Q1. How can i use a cursor under a particualar Select e.g.
>
> Select 4
>
> Select * From Astock2 into cursor Tc_As
>
> I want that Select area 4 Assign to Tc_As How can i do this?

CLOSE TABLES ALL
CREATE CURSOR theTable (test i)
SELECT * FROM theTable INTO CURSOR temp
SELECT 4
USE DBF('temp') AGAIN ALIAS tc_As
? SELECT() && 4


But as you probably know, it's not a good idea to use work-area numbers in code.


hth
-Stefan

ENTIRE THREAD

Sql Select Cursor to be use in Select Posted by Khurram Tahir @ 12/29/2008 11:10:24 AM
RE: Sql Select Cursor to be use in Select Posted by Stefan Wuebbe @ 12/29/2008 11:38:07 AM
RE: Sql Select Cursor to be use in Select Posted by Anders Altberg @ 12/29/2008 5:47:04 PM