Tough to identify that - you "should" know the structure of the database you are working with. That said, a common source of this error is forgetting a populate a field that is supposed to have a value.
If a field (for instance, a primary key) is supposed to be unique, and it's enforced at the structure level, then "blank" is considered non-unique. HTH sincerely,m|a "The only reason some people get lost in thought is because it's unfamiliar territory." -- Paul Fix ----- Original Message ---- From: James C Baxter <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent: Monday, July 10, 2006 7:55:49 PM Subject: [Active4d-dev] Create record via form with unique data field Hello Everyone, A couple of weeks ago a couple of people helped me out by showing me how to create a record in a table via a form. I am using the following code. create record(PackingSlip) [PackingSlip]TicketID:=num(f_ticketid) [PackingSlip]Ship_Via:=$f_ship_via save record(PackingSlip) The variables that start with an 'f' is the data from the form. If the form is used, a dialog box appears on the 4D Web server client stating 'Attempting to write non-unqiue data to a table with a unique field'. I do not have access to the structure for this install of 4D. Can anyone give me some pointers on how to identify the unique field and how I should populate it? Thanks very much. James C. Baxter Graphic Technology Specialist, Clemson Graphic Communications Hub, International Paper. Email: [EMAIL PROTECTED] Telephone: 864-633-6015 _______________________________________________ Active4D-dev mailing list [email protected] http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/ _______________________________________________ Active4D-dev mailing list [email protected] http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
