israelm
New Member
Hi there,
I am having a little troubles with temp tables, basically i don't know their life cycle, i know how to create them, i use the next code:
I read it this way:
So far everything is ok, but there are some times that i need to read the TT before it has been created, i need to know if it is already created before try to show it otherwise im gonna get an error.
Need to know how to know if it already exist and how to destroy it (once my process has finished need to delete it to continue creating a new one)
If i don't destroy it, how long is gonna be available on the server?
Btw... When i have already created one and i perform some changes on it's fields then get this error message: (I guess it's caused since table already exist and i am trying to modify it)
WebSpeed Error Messages
In procedure progs/norder.html, shared temp-table tOrder__ has a conflict in field, index or undo status. (2075)
Application Error
Unable to run Web object 'progs/norder.html'
Version: 10.2.0.00
OpenEdge Release: 10.2A
Thank's in advance.
Best Regards!
Israel M.
I am having a little troubles with temp tables, basically i don't know their life cycle, i know how to create them, i use the next code:
Code:
DEFINE NEW GLOBAL SHARED TEMP-TABLE tOrder__ NO-UNDO
FIELD cust_id LIKE customer.cust_id
FIELD item_id LIKE item.item_id
FIELD item_desc LIKE item.item_desc
FIELD item_cost LIKE item.item_cost
FIELD item_count AS INT
FIELD warehouse AS CHAR
INDEX x cust_id.
Code:
DEFINE SHARED TEMP-TABLE tOrder__ NO-UNDO
FIELD cust_id LIKE customer.cust_id
FIELD item_id LIKE item.item_id
FIELD item_desc LIKE item.item_desc
FIELD item_cost LIKE item.item_cost
FIELD item_count AS INT
FIELD warehouse AS CHAR
INDEX x cust_id.
FOR EACH tOrder__ NO-LOCK:
{&OUT} tOrder__.cust_id.
END.
Need to know how to know if it already exist and how to destroy it (once my process has finished need to delete it to continue creating a new one)
If i don't destroy it, how long is gonna be available on the server?
Btw... When i have already created one and i perform some changes on it's fields then get this error message: (I guess it's caused since table already exist and i am trying to modify it)
WebSpeed Error Messages
In procedure progs/norder.html, shared temp-table tOrder__ has a conflict in field, index or undo status. (2075)
Application Error
Unable to run Web object 'progs/norder.html'
Version: 10.2.0.00
OpenEdge Release: 10.2A
Thank's in advance.
Best Regards!
Israel M.