SQL UPDATE/SET/WHERE statement
I have a DB with 12 columns and hundreds of row with a key on the Smartrac_No. I have created forms in FP2000 to allow a user to add, change or delete rows of information. The following is my SQL statement in the updaterecord.asp: UPDATE smartracs2004
SET Description='::NewDescription::'
WHERE Smartrac_No='::Smartrac_No::'
I receive this message:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
Number: -2147217913 (0x80040E07)
Source: Microsoft OLE DB Provider for ODBC Drivers
When I change the ':: to " I receive this message:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers
What is the proper statement for this update.
Thanks
Software/Hardware used:
Software/Hardware used:
ASKED:
August 4, 2004 12:08 PM
UPDATED:
August 4, 2004 1:04 PM
Answer Wiki:
Notice your first error message. It appears that the syntax was fine, rather the problem was what you were trying to store in the database.
Your error message.
Data type mismatch in criteria expression.
My guess would be that you are trying to populate a numeric field in your database with a char.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
