How do I know if SELECT... finished if ESCAPEd? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How do I know if SELECT... finished if ESCAPEd?

Message

De

08/08/1997 15:05:22

Larry Moody
Las Vegas, Nevada, États-Unis

À

Tous

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

How do I know if SELECT... finished if ESCAPEd?

Divers

Thread ID:

00043773

Message ID:

00043773

Vues:

74

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

Click here to load this message in the networking platform