I'm using @STATION as part of a key for storing temp records by user session.

i.e. 123456*@STATION for unique records in the same table.

I have set the SYSENV*ENV_MYAPP record <32> to call SET_STATION*MYAPP

In SET_STATION I am setting @STATION to be…

Station = username:"$":computername:"$":processId:"$":Date():"$":Time()

I have set an index on my temp table STATION_ID key part 2 field for easy retrieval.

I am wondering if there are any caveats to setting @Station this way. For example length of @Station. The presence of the dollar signs "$", etc.

Any information is appreciated. TIA

PS. Since the life span of these records is relatively short, 10 mins or less, I'm only concerned about users that forget to log off or go into the debugger. With the above information I can quickly identify which users (at least) set the record, from where and when and release if necessary.

b. cameron

www.alternativesystems.net

603-433-0014

Not sure if there are issues but why use date if they have 10 minute span. I would think computername and time would suffice.

View this thread on the Works forum...