|
| | | StrataFrame Beginner
 
Group: StrataFrame Users
Last Login: 07/03/2008 8:49:49 AM
Posts: 30, Visits: 269 |
| 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....
|
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 06/17/2008 9:28:35 AM
Posts: 2,649, Visits: 1,863 |
| 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.
www.bungie.net |
| |
|
|