Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
'Dynamic' SQL
Message
From
23/01/2001 07:11:42
Gad Hutt
Express Print
Herzliya, Israel
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
'Dynamic' SQL
Miscellaneous
Thread ID:
00467190
Message ID:
00467190
Views:
40
Hi All,

I need to perform a SQL query number of times and gather the data into the same CURSOR. I can't use subqueries because the number of SQL is data dependent. I want to perform somthing like the following:

local i
...
Do while i>0

Select ...
from..
where i=somthing into cursor MyCursor

Enddo

I basicly need a way to APPEND to the cursor ...

Many Thanks,
Gadi Hutt
Next
Reply
Map
View

Click here to load this message in the networking platform