Nadeem
|
Posted: 06/26/2001, 1:46 PM |
|
Hi!
I have a table called OrderToAS400 where WSORDERNO is field. I want this
field to be filled with increment of value "1" whenever someone checkout.
Can someone tell me what ASP code I have to write in BEFORE EVENT which will
check last row with lastest WSORDERNO and add "1" to it. Please note this
can be done easily in MS ACCESS but I can not use this feature as I have to
deal with DB2 table (which don't have autonumbering option).
I have similar question about OrderDate. I want system date which has to be
written in format YYYYMMDD. How I have to do this? I know to in date Label,
one can mention it as Date and default value =Now() but this also bring Time
and date format is not acceptable. Please help.
Thanks and I appreciate to hear from you very soon.
Nadeem
|
|
|
|