Re: Accessing tmp tables in 4gl program

Hi ! Yes, you can access a temp table fields and values created in a called SP. But with few restrictions 1. A Temp table is created when the SP was called, hence it is not available before it, so no records defination ( RECORD a.* like temp.* ) can be made. Coz, at the time of compliation it looks for the table defination and field names, which are not available. 2. You cannot fire a query on a temp table fields or use any fields of temp table before calling SP. i.e, before creating temp table. But this talbe will be available to u till u exit of the program, i.e., it doesnt gets deleted when u come back to 4GL program from SP. I hope tht i was of some help. If i am wrong , pl. let me know. Thanks and good luck, Nayan ! - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - "People generally quarrel because they cannot argue." -Gilbert K. Chesterton