Hi,
Though it is maybe not the expected answer to your question, it could be
a solution for your problem.
What you can do is create the temp table once and then only delete all
the rows when you start the procedure.
Tony
Op 27-05-2023 om 05:35 schreef Doug Hamilton:
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
--
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/ba5ef9c1-db11-2b76-c819-d7a5c318d6e3%40cio-bv.nl.
