Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I know if SELECT... finished if ESCAPEd?
Message
From
11/08/1997 12:42:57
 
 
To
08/08/1997 16:13:27
Larry Long
ProgRes (Programming Resources)
Georgia, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00043773
Message ID:
00044006
Views:
31
Uh, well, no...

I used to use this in Clipper, too!

Guess I had a "memory error" there for a minute, thanks for the feedback.


>Have you tried using..."IF LASTKEY()=27..."?
>
>>I have a built-up command as follows:
>>
>>cCommand = 'SELECT * FROM WHERE'
>>cCommand = cCommand + ' THIS_TEST '
>>cCommand = cCommand + ' THAT_TEST '
>>cCommand = cCommand + ' INTO CURSOR MyCursor'
>>
>>Then I run it using &cCommand But I allow the user to ESCAPE out of the process if they wish. How do I know if the SELECT statement finished or if it was aborted? I don't know beforehand, how many records to expect so I cannot test reccount(), is there another way?
>>
>>I've used ON ESCAPE DO CancelSQL, then set a flag in CancelSQL but this requires a seperate procedure file. I was hoping to simply test a system variable or something like that.
>>
>>Thanks in advance
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform