I create a temporary table in a form's On Before Start EEP
The form is run dozens of times a day.
Once or twice a week I trap an SQL 2440 error, "Unavailable resource
encountered during <command> command".
This is not machine-specific, it occurs on several computers.
SCRATCH is set to TMP - local C:\Users\...\Temp
WAIT TIME is 15 seconds.
INTERVAL is .5 seconds.
What could be causing the error message? What resource could be
unavailable?
Or is it a red herring message and it's really something else?
Code is below.
The [error routine] allows up to 4 tries to loop back and create the table.
It usually works the second time; once in a great while it fails after 4
tries and I exit the program.
TIA & Happy Memorial Day weekend - take a moment to reflect.
Doug
SET ERROR MESSAGE 2038 OFF
DROP TABLE tSHPT
SET ERROR MESSAGE 2038 ON
CREATE TEMPORARY TABLE `tSHPT` +
(`PIKD_ID` INTEGER, +
etc )
SET VAR vSQLCode = .SQLCODE
IF vSQLCode <> 0 THEN
[error routine]
ENDI
--
This email has been checked for viruses by Avast antivirus software.
www.avast.com
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/83ca8547-99bc-0b03-214f-f3de6216bc8e%40wi.rr.com.
