OleDbCommand parameter datatype marshalling issue with MS Access

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

[Miha Markic]

Hi,

What does your sql commandy look like?

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com

<di********@discussion.microsoft.com> wrote in message
news:uv**************@TK2MSFTNGP11.phx.gbl...

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


"Miha Markic" <miha at rthand com> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...

Hi,

What does your sql commandy look like?

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com

<di********@discussion.microsoft.com> wrote in message
news:uv**************@TK2MSFTNGP11.phx.gbl...

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

[Miha Markic]

> I fixed the UPDATE query.

Its a bug in MS Access 2000 SR3

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

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com