A couple of thoughts: What MDAC driver version are you running? Make sure
you are at least at 2.1. Some of the older drivers had bugs. Which FoxPro
driver are you using for the ODBC connection? If you have upgraded your
MDAC drivers you might have a "Microsoft FoxPro" driver and a "Microsoft
Visual FoxPro" driver. Use the "Microsoft Visual Foxpro" driver. The other
driver is VERY flaky. Finally make sure you have selected either the
Database or free table option properly. If the table you are accessing is
part of a database then you must select the database.
Hope this helps.
______________________________________________________
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: Wed, 10 May 2000 10:00:01 +0100
> From: Michael O Reilly <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: RE: Boolean fields in Foxpro
> Message-ID: <ECE6504EA487D3118D8A00805F59102E7EB25F@NT_BACKUP>
>
> Larry,
> Thanks for the reply, apologies for not getting back sooner.
> <CFQUERY>
> INSERT INTO Tablename (BooleanField) VALUES (.T.)
> <CFQUERY>
>
> Sorry, but this doesn't work for me.
>
> I've also tried this code in Borlands SQL explorer using the
> ODBC connection
> to the database I'm using. As I suspected Access (i.e. Jet)
> was doing some
> conversion to make the SQL I was testing work with the
> linked ODBC Foxpro
> databases. But when using just ODBC (i.e. in CF or SQL
> explorer with Jet out
> of the equation) you get an error if the ODBC datasource
> doesn't like your
> SQL.
>
------------------------------------------------------------------------------
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.
