Thank you!!!
Donna French
-----Original Message-----
From: G [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 1:37 PM
To: CF-Talk
Subject: Re: Access > SQL Question
SQL Server manages auto-incremented fields differently than Access does.
I believe you have to go into SQL Server Enterprise Manager and modify
that field in the table so that SQL Server knows it is an autonumber
field.
----- Original Message -----
From: Donna French
To: CF-Talk
Sent: Wednesday, August 18, 2004 1:17 PM
Subject: Access > SQL Question
I have a table that I transferred from Access to SQL and had a field
setup as auto number. Now I am getting an error message when I try to
submit new info to the table in SQL.
Here's the error:
ODBC Error Code = 23000 (Integrity constraint violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value
NULL into column 'id', table 'mydatabase.user.tblMemo'; column does
not
allow nulls. INSERT fails.
The error occurred while processing an element with a general
identifier
of (CFINSERT), occupying document position (6:1) to (11:28).
Here's the CFInsert code:
<cfinsert dbname="mydbname"
username="myusername"
password="mypassword"
datasource="mydsn"
tablename="tblMemo"
formfields="subject, memo">
Any help appreciated.
Thank you,
Donna French
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
