Try removing the ' ' marks.
In Boolean fields, some applications do not need them
----- Original Message -----
From: "Michael O Reilly" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 08, 2000 4:41 AM
Subject: RE: Boolean fields in Foxpro
> Hi All,
>
> I'm having a simple problem I'm sure someone has come up against before.
> I developed a CF system with an Access backend.
> This was then ported to Foxpro.
> Nearly everything worked fine but I'm having a problem setting Boolean
> fields.
> When I try the following -
>
> <CFQUERY>
> INSERT INTO (Tablename.BooleanField)
> VALUES ('0')
> <CFQUERY>
>
> - I get a ODBC Data mismatch error.
>
> I've tried the following in values and still got errors
>
> VALUES(0)
> VALUES('TRUE')
> VALUES (TRUE)
>
> The original query works fine when I run it against the Foxpro tables
linked
> into Access.
> I presume that JET is doing some sort of Access -> ODBC conversion for me.
>
> Anyone out using Foxpro able to help?
>
> Regards
> Michael O'Reilly
> TransAer
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
