Re: temp tables and rowid

In article <6kv5ad$1e3$1@nnrp1.dejanews.com>, mabinm@valuerx.com writes >Before I'm told that I shouldn't use rowids, I don't have a lot of choice >right now, given that this application was designed this way and I have been >given the task of pointing it to a different database. Here's the situation: > >My application executed a select into temp table query. It then did a select >on the temp table limiting the results returned by rowid. What worked in the >former database leads to an error 857 "rowids do not exist on table" in the >new database. Are there any parameters that might be set to cause the >creation of temp tables without rowids? Another note of interest, both >databases have tables with rowids on them. > You can you create table.... with rowids try the select..into temp... with rowids syntax (Might not be valid) >Hope someone can help. > >Thanks. > >Mike > >-----== Posted via Deja News, The Leader in Internet Discussion ==----- >http://www.dejanews.com/ Now offering spam-free web-based newsreading -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care