How about not dropping the table but just updating it with your dynamic SQL
statement. And then using the query.
-Nimmi
-----Original Message-----
From: Andy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 15, 1999 9:51 AM
To: NetDynamics Support
Subject: [ND] Using Tempory tables
Hi All
Has anyone ever experimented using temporary tables with ND?
I need to dynamically create quite a large SQL statement using
setSqlTextFull and place it into a tempory table and then run a query
against that ( I have to do this as part of the select has to incorporate
checking against a large SUM aggregate from the first sql statement -
something you can't do in Informix). My problem is; how do I create a page
and data object against a table that only exists when a session is live? Is
it a case of first having to create a table in the databsae, designing the
form and data object against that, dropping the table and hoping that ND
won't have a problem trying to find a non existant table? Or is there an
easier way?
Regards
Andy
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
