Yeah, without FoxPro it becomes much more difficult to figure out what is
happening. You are correct, the database container contains the complete
structure of all the tables in the database. It also contains any
relationships between the tables and any triggers.
Have you tried to have the client send you a copy of the table structure? I
would have them do the following in FoxPro:
USE <tablename> IN 0
SELECT <tablename>
LIST STRUCTURE NOCONSOLE TO FILE <filename>
Then have them send you the file created in the 3rd step. You should get
something similar to the following:
Structure for table: D:\WORKING\WORK2\TEMP1.DBF
Number of data records: 117
Date of last update: 12/13/1999
Code Page: 1252
Field Field Name Type Width Dec Index Collate
Nulls
1 CUSTNO Character 6
No
2 CHECKNO Character 6
No
3 TRANSDATE Date 8
No
4 PAYEE Character 40
No
5 AMOUNT Numeric 9 2
No
6 JOBNO Character 6
No
7 TYPE Character 1
No
** Total ** 77
What you are looking for is your field and it's type. Make sure it is
"Logical". The field has to be a Logical field to accept true and false.
______________________________________________________
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 14:15:18 +0100
> From: Michael O Reilly <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: RE: Boolean fields in Foxpro
> Message-ID: <ECE6504EA487D3118D8A00805F59102E7EB26B@NT_BACKUP>
>
> Bill,
> Thanks for the Tips
> I'm using the very latest version of MDAC (2.5) I'm also
> using the Visual
> Foxpro Driver VFPODBC.DLL Version 6.01.8629.01.
> When trying to create a DSN using the Microsoft Foxpro Driver
> (ODBCJT32.DLL
> version 4.00.4403.02) an error message appears saying "The
> Microsoft Foxpro
> Driver is no longer supported, and has been replaced by the
> Microsoft Visual
> Foxpro driver"
> I'm using the .dbc option (rather than free tables)
> I originally designed the Db in Access. The Client uses
> Foxpro and did the
> conversion. I'm assuming that the .dbc contains a desciption
> of all fields
> in the database.
> Since I don't have Foxpro, I have no way of checking this.
> I looked on Microsft's Foxpro documentation on MSDN but of course the
> examples of Inserting records di not have any Boolean field's in it.
> I'm close to giving up on this. I think I'll advise the
> Client to change the
> Boolean field to a Byte (TinyInt) and using 0 for False and 1
> for True.
>
> Regards
> Michael O'Reilly
> Analyst Programmer
> 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.
