Re: Accessing tmp tables in 4gl program

You can use the temporary table created in stored procedure. BUT, you can't use any RECORD LIKE temp_table.* (or any LIKE temp_table.column) Best Regards, Octav On Fri, Apr 23, 1999 at 09:24:48PM +0000, krishnakn@yahoo.com wrote: > > > Is it possible to access the tmp table created in the Stored procedure in the > 4gl program ????? > > I'm calling a SP in my 4gl program. > The SP creates a temp table and fills some data. > > I need to access this table in my 4gl program after calling the SP.... > > It gives me compilation error saying the tmp table not found in the database > ??? > > Pl. help me out !!!!!!!! > > The following is the code .. > > DATABASE apstst > > MAIN > > PREPARE s1 FROM "execute procedure p_crtreftabs ()" > > EXECUTE s1 > call select_func() > END MAIN > > function select_func () > define r_applacct RECORD LIKE t_tabname_list1.* > > declare acct_curs CURSOR FOR > SELECT * FROM t_tabname_list1> > FOREACH acct_curs INTO r_applacct.* > DISPLAY r_applacct.* > > END FOREACH > > end function > > TIA, > > krishnakumar > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com