I can't believe that this is causing me so much grief.
Last night I tried the following
<CFQUERY>
INSERT INTO (Tablename.BooleanField)
VALUES ('.T.')
<CFQUERY>
I also tried
VALUES (.T.)
VALUES ('T')
VALUES (T)
VALUES ('#.T.#')
and none of these work.
The strange thing is that I can add records using SQL through Access (
although I suspect that Jet is doing conversion on the SQL) and then update
the field using
<CFQUERY>
UPDATE Tablename SET Tablename.BooleanField = 0
WHERE Tablename.CompanyID = 5
<CFQUERY>
or
<CFQUERY>
UPDATE Tablename SET Tablename.BooleanField = 1
WHERE Tablename.CompanyID = 5
<CFQUERY>
will toggle the field to True or False
-----Original Message-----
From: Bill Grover [mailto:[EMAIL PROTECTED]]
Sent: 08 May 2000 13:32
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: RE: Boolean fields in Foxpro
I just caught up with the thread, I would be very surprised if the .T.
doesn't work. My understanding (I don't pretend to be the final expert) is
that ODBC takes whatever you give it and passes it through to the backend
database. Now for some database types it has to manipulate it a lot but for
something like FoxPro that understands SQL commands ODBC would just pass the
command to the FoxPro engine as you enter it.
Therefore FoxPro only understands the .T. and .F. as true and false so you
need to use them.
Best of luck!
______________________________________________________
Bill Grover
Supervisor IS Department Phone: 301.424.3300 x396
EU Services, Inc. FAX: 301.424.3300 x1396#
649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED]
Rockville, MD 20850-1299 WWW: www.euservices.com
______________________________________________________
> -----Original Message-----
>
> Date: Mon, 8 May 2000 10:44:34 +0100
> From: Michael O Reilly <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: RE: Boolean fields in Foxpro
> Message-ID: <ECE6504EA487D3118D8A00805F59102E7EB224@NT_BACKUP>
>
> Thanks for the help, much appreciated. I'll try '.T.'
> I remember that notation from my DBaseIV days.
>
>
> Regards
> Michael O'Reilly
> TransAer
>
<snip>
----------------------------------------------------------------------------
--
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.
