Actually it is doing it for all the fields. Now I am really confused.
James Taavon wrote:
>
> 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.
------------------------------------------------------------------------------
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.
