Hi All,

I am working on remedy support system where call are logged in different area Hardware,Application etc............
Toady I faced a Unique Problem.actually when call are logged a Unique call is given to all call which is selected from a table..

code........

ssql = "select 'HD'||LPAD(nextid,13,'0') from arschema where schemaid=160"
Set rs = OraDatabase.DbCreateDynaset(sSql, cint(0))
seq = rs(0)
OraDatabase.DbExecuteSql("Update arschema set nextid = nextid + 1 where schemaid=160")

This code is written in 3 application files for Logging different type of calls.

After selecting number,number is updated.

Bt today Morning call was logged and 3 problems had given the same Problem Number.

I m not able to get the Problem........

Pl help meeeeeeeeee



It is always safe to assume, not that the old way is wrong, but that there may be a better way...
*************************
Rekha

__________________
It is always safe to assume, not that the old way is wrong, but that there may be a better way...
*************************
Rekha