Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Really easy one, cursors
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00723333
Message ID:
00723341
Views:
10
This message has been marked as a message which has helped to the initial question of the thread.
Try to add nofilter clause to your select.
select Stref as stkref, Stdesc as stkdesc ;
     from lfkma01 ;
     where stref BETWEEN lclvalue1 AND lclvalue2 ;
     into cursor tempcursor NOFILTER
sele (lcf1)
append from (dbf('tempcursor'))
>here is a really easy one for you all but i am having real trouble with it.
>the code is below just in case. i am trying to append from a cursor into a temp file but i cannot get the information into the cursor.
>
>
>*this select statement works fine, the brow below it
>* sows the correct results
>sele Stref as stkref, Stdesc as stkdesc ;
>     from lfkma01 ;
>     where stref => lclvalue1 AND stref <= lclvalue2 ;
>     into cursor tempcursor
>
>     brow
>
>* here i am selecting the temp file to append into
>sele &lcf1
>
>* this command is not appending the values from the tempcursor variable
>append from dbf('tempcursor')
>
>brow
>
>Cheers
>
>~M
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform