adding fields t temp table

[sureshp]

I hav defined a temp table. now my prob is I want to add som fields in the middle of program. how do i do tat

 

[Casper]

You can only add fields dynamically before the prepare statement.

Casper

 

[jongpau]

The only way to do this is by using a dynamic temp-table. But, once a dynamic temp-table has been prepared you cannot change it anymore (and you must prepare the temp-table before you can use it).

A static temp-table (one that you "set up" by using a DEFINE TEMP-TABLE statement) can not be changed at all.

Paul

 

[DevTeam]

Maybe you could declare a new temp-table like the first one and containing the new field, and then copy/paste data from one to the other...

Ugly and slow for sure... !

EDIT : and of course you'll then have to use the name of the second one in your code....