Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I know if SELECT... finished if ESCAPEd?
Message
From
08/08/1997 15:05:22
Larry Moody
Las Vegas, Nevada, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
How do I know if SELECT... finished if ESCAPEd?
Miscellaneous
Thread ID:
00043773
Message ID:
00043773
Views:
72
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
Next
Reply
Map
View

Click here to load this message in the networking platform