yeah I used to get this one alot if I ran the code on a form or reports 'on
before start eep' and sometimes I get it out of the blue so I added the
following code for all my temp tables...
SET VAR vCheckForTbl INTEGER ='0'
SELECT COUNT(*) INTO vCheckForTbl FROM SYS_TABLES WHERE SYS_TABLE_NAME
='att_ItemsPaidBy'
IF vCheckForTbl ='0' THEN
CREATE TEMP TABLE `att_ItemsPaidBy` ..
ELSE
DELETE FROM att_ItemsPaidBy
ENDIF
CLEAR VAR vCheckForTbl
Once in a great while, I'll sometimes get an error that it couldn't delete
and end up with the previous recs but I've added double checks in the areas
that are important to not have the other recs.
----- Original Message -----
From: "Dan" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, December 11, 2009 7:57 AM
Subject: [RBASE-L] - resource unavailable
Hi
Finally made the switch to Turbo, having trouble with a drop command>
DROP TABLE fileproc1
CREATE TEMPORARY TABLE `FileProc1` (`FullFilename` +
TEXT (100) , `RealFileName`= (SGET(fullfilename,25,43) ) TEXT
(50) )
CREATE INDEX relfn1 ON `FileProc1` (`RealFileName` ASC SIZE 50 )
The first time through this eep, no table, so all is ok, then it creates
the table ok... next time the eep runs it can't drop the table, I get:
-ERROR- DROP aborted, resource unavailable (380)
