Where can I find temp-table definition

Posted by LegacyUser on 25-Jan-2001 11:50

Does temp-table definition can be found in the metaschema _file and _field ?

I have a program that was written by someone else, and leads with temp-table. I don't have the .p code of this program, only the .r. This program calls another one that I have the .p code and would like to make some changes on it.

How can I discover the temp-table deffinition.

Thanks a lot for the Help.

Sinval

All Replies

Posted by LegacyUser on 31-Jan-2001 10:06

Hi,

Programmers define a temp-table as part of the code, the table is not part of teh physical database as it only exists as long as the code is active.

eg

def temp-table mytable

field f1 as int

field f2 like databasetable.fieldname.

The table can be used by the program but as soon as the program terminates the table ceases to exist.

"Sinval" wrote:

>

>Does temp-table definition can be found in the metaschema

>_file and _field ?

>

>I have a program that was written by someone else, and

>leads with temp-table. I don't have the .p code of this

>program, only the .r. This program calls another one

>that I have the .p code and would like to make some changes

>on it.

>How can I discover the temp-table deffinition.

>

>Thanks a lot for the Help.

>

>Sinval

Posted by LegacyUser on 08-Feb-2001 13:52

How can I discover the temp-table deffinition.

Well, if you have the source to the target

program and can compile it unchanged, you've got

to have the temp-table definition in it in the .p

or a .i file somewhere. Unless, of course, you're

using V9, in which case you can use the BUFFER

handle of the temp-table to examine the underlying

buffer and buffer-fields.

Grieg Pedersen

Progress Consultant

This thread is closed