control + break

LGarcia · Feb 8, 2005

Hi All,
I have an AXP app that runs numerous queries which take a long time to
complete. I have a splash screen that appears as these queries run with the
message that states "This may take a long time - Please Wait...". But some
of my impatient users are using control + break to stop the process. This is
causing problems. Is there a best way to handle my impatient users and their
control+break keystrokes through code? Rolled up newspapers aren't
working......
Thanks,
LGarcia

Allen Browne · Feb 9, 2005

Presumably these are action queries if they are messing up the data?
If so, you could Execute them instead of using RunSql, e.g.:
dbEngine(0)(0).Execute "MyActionQuery", dbFailOnError

If necessary, wrap them in a transaction so you can rollback. Details and
pitfalls in:
http://members.iinet.net.au/~allenbrowne/ser-37.html

LGarcia · Feb 9, 2005

Thanks Mr Browne. Your presumption is correct and I will attempt to utilize
your suggestions.

control + break

LGarcia

Allen Browne

LGarcia