I am in the process of re-creating the back-end on one of my apps from
DB2/NT to AS/400 mainframe. I am running into a problem with the "date"
field. In my situation, many requests will come in on the same day.
Currently with DB2/NT as my back-end everything is fine. When I perform
the same action with my newly created database in AS/400 I get a
"Duplicate key value specified". I dont understand why it wont let me
insert another row even though it has the same date ("date" is not the
primary key). I am using DateFormat Now() for inserting the date. "Time"
is the primary key in the table that the data in being inserted into,
using TimeFormat Now() for that.
Any ideas on why this is happening. Let me know if you need further
explanation.
James
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
