From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr
Sent: Thursday, January 2, 2014 11:21 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: TEMP TABLE
“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.”
Try to create a form (that is not a variable form) without a primary table.
If you succeed then you will know that you are not trying to do something
impossible <g>.
If you fail then I see two possibilities: firstly move your code to drop the
table to the line in your application after the call to the form.
If that doesn’t suit you there is an “On Close” form EEP that may be able to
close the form and then drop the table – I’ve never tried it.
Regards,
Alastair.
From: Kramer, Jason J <mailto:[email protected]>
Sent: Thursday, January 02, 2014 3:24 PM
To: RBASE-L Mailing List <mailto:[email protected]>
Subject: [RBASE-L] - RE: TEMP TABLE
If you comment out the DROP line and let the form continue closing, does the
TEMP table still exist?
Jason
Jason Kramer
University Archives and Records Management
002 Pearson Hall
(302) 831 - 3127 (voice)
(302) 831 - 6903 (fax)
-----Original Message-----
From: [email protected] <mailto:[email protected]> [mailto:[email protected]]
On Behalf Of Jim Belisle
Sent: Thursday, January 02, 2014 10:22 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: TEMP TABLE
I have done that. All code works as planned until I come to the last lines that
DROP the table.
I then get the error message even though I have that message off.
James Belisle
Making Information Systems People Friendly Since 1990
-----Original Message-----
From: [email protected] <mailto:[email protected]> [mailto:[email protected]]
On Behalf Of Buddy Walker
Sent: Thursday, January 02, 2014 9:16 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: TEMP TABLE
Can you put a "Trace ON' just before calling the form and bit button to step
through to see what is happening?
-----Original Message-----
From: [email protected] <mailto:[email protected]> [mailto:[email protected]]
On Behalf Of Jim Belisle
Sent: Thursday, January 02, 2014 10:12 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: TEMP TABLE
No disconnect. This is a form within my application.
I am just using the CLOSEWINDOW code to get back to the main menu.
James Belisle
Making Information Systems People Friendly Since 1990
-----Original Message-----
From: [email protected] <mailto:[email protected]> [mailto:[email protected]]
On Behalf Of Buddy Walker
Sent: Thursday, January 02, 2014 9:07 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: TEMP TABLE
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]> [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
