Jim Do you disconnect or re-connect to the database in your code is so that could be causing your temp table dropping.
Buddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, January 02, 2014 9:57 AM To: RBASE-L Mailing List Subject: [RBASE-L] - TEMP TABLE I am working with two forms where one form comes (form A) up then when I am finished with form A I close the form and bring up form B. When done working in form B I hit a bit button that closes the window and performs other code. Here is my problem. Form B is based on a temp table and the very last code in the bit button when closing this form is to DROP the temp table. I set the error message 2038 off and the temp table updates the regular tables per the code. However I continue to get the error message 2038 stating the temp table is not defined. Another aspect to this is that this happens ONLY after adding rows to another temp table through a DBGrid on Form B. The error codes do not appear when adding the row. Just when the code runs through the Bit Button. Any suggestions? James Belisle Making Information Systems People Friendly Since 1990 --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
