David McConnell
|
| Posted: 09/28/2002, 5:55 PM |
|
Hi,
I'm using CodeCharge Studio 1.07 to develop a web application. The database
on the backend if MS Visual Foxpro 7.0. I'm connecting CodeCharge through
the latest VFP ODBC driver. Whenever I add a new record through my ASP
page, it gets the following error:
========================================================================
Source: Record departments / Insert Operation
Command Text: INSERT INTO departments(description) VALUES ('Personnel')
Error description: [Microsoft][ODBC Visual FoxPro Driver]Uniqueness of index
ID is violated. (Microsoft OLE DB Provider for ODBC Drivers)
INSERT INTO departments(description) VALUES ('Personnel')
========================================================================
I do have a primary key set for each table, and a stored procedure that
increments the key upon record insert. This functionality works fine if I
do the insert within Visual Foxpro, but not through the ASP page.
Does anyone have any ideas on what could be causing this?
Thanks,
David McConnell
|
|
|
|
Allen Harkleroad - Microsoft MVP
|
| Posted: 10/01/2002, 3:38 AM |
|
on the pages you generated did you set it to auto-increment the key or not?
It is a problem with the Primary Key being added (I usually let the database
do that work) or it is trying to insert a NULL in the primary key.
Allen
--
Allen Harkleroad
Microsoft Windows NT MVP - 1996-2002
GMP Services, Inc.
www.gmpservices.com
WARNING: I cannot be held responsible for the above because my Aloe plants
have apparently learned to type.
"David McConnell" <david.mcconnell@telocity.com> wrote in message
news:an5j24$jdo$1@news.codecharge.com...
Hi,
I'm using CodeCharge Studio 1.07 to develop a web application. The database
on the backend if MS Visual Foxpro 7.0. I'm connecting CodeCharge through
the latest VFP ODBC driver. Whenever I add a new record through my ASP
page, it gets the following error:
========================================================================
Source: Record departments / Insert Operation
Command Text: INSERT INTO departments(description) VALUES ('Personnel')
Error description: [Microsoft][ODBC Visual FoxPro Driver]Uniqueness of index
ID is violated. (Microsoft OLE DB Provider for ODBC Drivers)
INSERT INTO departments(description) VALUES ('Personnel')
========================================================================
I do have a primary key set for each table, and a stored procedure that
increments the key upon record insert. This functionality works fine if I
do the insert within Visual Foxpro, but not through the ASP page.
Does anyone have any ideas on what could be causing this?
Thanks,
David McConnell
|
|
|
|
|
|
