OleDbCommand parameter datatype marshalling issue with MS Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,


When I create a table in MS access 2000 with SR3 using a standard SQL
Create command
The BOOL (YesNo) columns are NOT checkboxes, they are ints.

When I create a table using the designer the BOOL YESNO fields are
checkboxes.

Smells like a BUG.

When I call OleDbCommand with a BOOL in the parameters to update, I get
"Syntax in UPDATE command" beecause this datatype
is not matching because of this bug.

The command runs fine when copy and pasted to the query window in MS
Access directly.

Smells like an Access and OleDb class bug
 
The SQL is fine, the MS Access has a bug on SQL CREATE commands and designer
for bool fields.

I fixed the UPDATE query.

Its a bug in MS Access 2000 SR3
 
I fixed the UPDATE query.
Its a bug in MS Access 2000 SR3
Click to expand...

I see.
Anyway, it couldn't be an OleDb bug since the sql stataments are passed
through without modifications.
 
Back
Top