By Crones - 3/22/2008
Is the term "Password" a reserved word in an Access 2007 Database?
I keep getting an Syntax Error in INSERT and on UPDATE commands when I have a field named "Password".
This was driving me nuts because looking at the DEBUG output of the command, it is valid...
INSERT INTO Users (Username, Password, DisplayName) VALUES (?, ?, ?);
Param0: 'Testing' [DbType: String | Size: 7 | Direction: Input | SourceColumn: Username | SourceVersion: Current]
Param1: 'Testing' [DbType: String | Size: 7 | Direction: Input | SourceColumn: Password | SourceVersion: Current]
Param2: 'DisplayName' [DbType: String | Size: 11 | Direction: Input | SourceColumn: DisplayName | SourceVersion: Current]
I don't recall having this issue in the past....
|
By StrataFrame Team - 3/24/2008
Yes, it might very well be a reserved word. Try calling that command directly on the database (not through the SF data source) and see if it executes (create a quick little test app to try it out). If it still gives you an error, then try putting [] around the "password" so it looks like [Password] in the command. If that works, then we'll need to modify our data source item to add the quoted identifiers for the field names.
|
|