473,386 Members | 1,793 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

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
Nov 15 '05 #1
3 2017
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

Nov 15 '05 #2
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


Nov 15 '05 #3
> 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
Nov 15 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: | last post by:
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...
1
by: Jason Steeves | last post by:
-Dim cmd As OleDbCommand -cmd = New OleDbCommand("select * from qmsstats where firstname='jason'", OleDbConnection1) -OleDbDataAdapter2.SelectCommand = cmd -DataGrid1.Visible = True...
14
by: Elias Farah | last post by:
Hi All, What are people's experience in timing Query Performance? I have tried in vain, but get many unpredictable results, with execution proceeding in the background and problems of timing...
6
by: Catherine Jones | last post by:
Hi all, we need urgent help in a matter. We are trying to pass a COM object from the client to server and are facing some problems in the same. We've our client in C# as well as the Server...
0
by: Frederico Guimar??es via DotNetMonster.com | last post by:
Hi, I'm trying to use the Microsoft.Web.Services2.Messaging. ISoapFormatter but I receive this error: System.Xml.XmlException: Reference to undeclared parameter entity, 'meetingmaker'. at...
2
by: DazedAndConfused | last post by:
I converted a C# example of using dll crypt32 to VB .NET. The converted example fails when Encypting/Decypting. I found that if instead of defining a variable as and setting the values for...
0
by: RG | last post by:
OleDbCommand.Prepare error: Size of parameter (VB.NET 2003) I need to do a SQL INSERT statement into an Access table, and I’d like to use the exact technique described in the Help file example...
10
by: Bryce Calhoun | last post by:
Hello, First of all, this is a .NET 1.1 component I'm creating. SUMMARY ----------------------- This component that I'm creating is, for all intents and purposes, a document parser (I'm...
2
by: calenlas | last post by:
Hi all, I'm taking my first steps into C# <--C++ DLL Interop and unfortunately I've run into (what seems to be) a very complicated case as my first task. Perhaps someone here can help me. I...
0
by: santoshdarekar | last post by:
HI, I have some code which I am reverse engineering. Here is one module which is used as calculation madule and marshalling is used in it. But, still there is performance issue as the CPU time the...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.