Reading a temp table
Posted in 1998
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
Hi Everybody I have a question on reading a temp table in Informix 4GL. In my Informix 4GL code, I am taking some input from user and based on that input I am creating a temp table and puting data into it from other tables. At any time this temp table may have one or five or seven or as many columns as possible. Now I want to read each column's data value. I am preparing a query (SELECT * FROM myTempTable) and declaring a cursor for this query. Now I want a loop of 'foreach' mycursor into ...... . But I donot have variables for into clause because I donot know how many I need and of what type. How can I solve this problem? Is there anyway of defining variables dynamically in Informix 4GL? Please help. Thanks in advance for you time and help. Regards, Iftikhar -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading