Going off the wall here again, when you used '#TRUE#'
did you also try it without the ' ' marks?
I know most Boolean uses 0 and -1 for other data types as
well. I am not sure in Foxpro.
Have you hit the HELP file in Foxpro?
When Boolean values are converted to other data types,
False becomes 0 and True becomes -1.
----- Original Message -----
From: "Michael O Reilly" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 08, 2000 4:51 AM
Subject: RE: Boolean fields in Foxpro
> I've already tried VALUES (0), I'm assuming that TRUE needs to be wrapped
in
> special char to identify it, the same way Dates need are Formatted as
> #dd/mm/yyy# but I tried '#TRUE#' and got an error.
>
> Thanks for the reply though.
> Regards
> Michael O'Reilly
> TransAer
>
>
> -----Original Message-----
> From: Randy Adkins [mailto:[EMAIL PROTECTED]]
> Sent: 08 May 2000 09:46
> To: [EMAIL PROTECTED]
> Subject: Re: Boolean fields in Foxpro
>
>
> 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.
> --------------------------------------------------------------------------
----
> 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.
