In the book by Microsoft 'Visual Foxpro 6.0'
Boolean fields such as checkboxes uses .T.
and .F. as well as 0 and 1, 2, and .NULL.
2 and .NULL. I have never used.
Sorry I am no Foxpro expert. If those
do not work, let me know, I will continue looking
in the book.
----- Original Message -----
From: "Michael O Reilly" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 08, 2000 5:19 AM
Subject: RE: Boolean fields in Foxpro
> If I used #TRUE# (without quotes) then ColdFusion would think I was
> referencing a variable called True.
> I could try it but I would expect an error.
> Unfortunately I haven't got Foxpro to look at the help.
>
> -----Original Message-----
> From: Randy Adkins [mailto:[EMAIL PROTECTED]]
> Sent: 08 May 2000 10:09
> To: [EMAIL PROTECTED]
> Subject: Re: Boolean fields in Foxpro
>
>
> 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.
> --------------------------------------------------------------------------
----
> 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.
