|
I am getting one of the following errors:
Data type mismatch in criteria expression
or
Syntax error in date in query expression
|
|
|
This error typically indicates that the gsSQLDateDelimiter setting needs to be changed. In the config file, you will see this setting near the bottom of the file. There are two valid possible values for this setting. One setting is enable, one is disabled. The disabled setting has the single quote ( ' ) character in front of it. To swap these settings, you need to add the single quote character to the enabled line, and remove it from the disabled line.
For example, if you had the lines shown here:
gsSQLDateDelimiter = Chr(35)
'gsSQLDateDelimiter = Chr(39)
You would change it so it looks like:
'gsSQLDateDelimiter = Chr(35)
gsSQLDateDelimiter = Chr(39)
If your config file looks like the bottom settings, you need to change it so it looks like the top.
|
