Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
APPEND FROM [SQL Cursor]
Message
From
22/12/2008 14:42:55
 
 
To
22/12/2008 10:09:43
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01369081
Message ID:
01369235
Views:
23
>>I do the same all the time, but I always start with a blank cursor. What happens if you do the same?
>
>Hi Tore,
> I tried your suggestion, I wrote CREATE CURSOR ... just prior to the SQL SELECT statement but again I received the same error.
>
> I wonder if it has to do with the fact that the cursor I created is based on another cursor which is also the result of an SQL-Select.
>
>Best regards, Chaim

Are you sure that the second select statement actually selects any records at all? If you try
Select ... into cursor somecursor readwrite && Your second select statement
Select 0 && Just to make sure that you are in another work area for a moment
Select dbf('somecursor') && If thie line errors, you have not selected any records!!
Browse && Do you see any records
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform