I'm not familiar with Paradox, but it looks like ordinary RDBMS problem.
1) I suppose that Account_ID is Primary Key.
Solution: generate another number for this field
2) It can be IDENTITY (Autonumber).
Solution: don't send any mention about this field in your INSERT
clause
Regards,
Gennadi
----- Original Message -----
From: "Jessica Ogle" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Thursday, November 09, 2000 9:52 AM
Subject: problems inserting into Paradox table
I am trying to write a ColdFusion application using Paradox tables. I can
read the tables just fine, but when I try to insert new records I am having
major problems. If the table is empty, the record goes in just fine, but if
there are any records in the table my query fails with the following
message:
Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Paradox Driver] Operation must use an updateable query.
SQL = "Insert into logon_log (Account_ID, User_Name) values ('12345'','John
Smith')" Data Source = "j_steers"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (9:1) to (9:48) in the template file
C:\Inetpub\wwwroot\web_steers\testquery.cfm.
Date/Time: 11/08/00 16:50:23
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 95)
Remote Address: 127.0.0.1
Does anyone know what I need to do to be able to insert? I haven't even
tried to update yet....
Thanks,
Jessica Ogle
----------------------------------------------------------------------------
--
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
