Re: Utilizing temporary tables via an ODBC connection?
This is a discussion on Re: Utilizing temporary tables via an ODBC connection? within the Informix forums, part of the Database Server Software category; --> Hi, The problem is that the results for the fist recordset are known for your app, but not fo ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 07:51 AM
| ||||
| ||||
 Re: Utilizing temporary tables via an ODBC connection? Hi, The problem is that the results for the fist recordset are known for your app, but not fo the database server. Have you tried someting like this? insert the rows for the first recordset in a temporary table link this table to other ones to get the second recorset In pseudocode (sorry, don't know the Visual FoxPro sintax): execute(select columns_for_the_fisrt_recorset from tables_for_the_fisrt_recorset where conditons_for_the_fisrt_recorset into temp temporary_1_recorset with no log) prepare( select columns_for_the_second_recordset from tables_for_the_second_recordset, temporary_1_recorset where conditions_for_the_second_recordset and conditions_linking_the_two_tables) get second recordset results. Hope it helps. William Fields wrote: >Thanks for the response, we've chosen not to make any server side mods, so >adding views or SP's is not in the gameplan. > >I was hoping I would be able to create/use temp tables via SQL over the ODBC >connection instead. > > > sending to informix-list      |
 |
« RE: rule of thumb or words of wisdom for btree cleaners?
|
RE: rule of thumb or words of wisdom for btree cleaners? »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 11:54 PM.
