Bill,
Apologies for not replying. The ISDN link for web and e-mail died on
Thursday and didn't come back until today.
After removing the Boolean field from the table, I discovered that the
numeric field I assumed was working correctly had been causing my problem
all along.
I am now able to add, modify and delete records using SQL.
I now have another problem. In Foxpro, records are marked for deletion. They
are only actually deleted when a PACK command is issued.
SQL delete command's only mark the record deleted.
I want to schedule a .cfm which will pack all the tables once a week.
Do you know anything about sending 'PACK' command to Foxpro within SQL.
I'm sure this problem would affect all Xbase derived databases.
Regards
Michael O'Reilly
Analyst Programmer
TransAer
-----Original Message-----
From: Bill Grover [mailto:[EMAIL PROTECTED]]
Sent: 11 May 2000 12:23
To: '[EMAIL PROTECTED]'
Subject: RE: Boolean fields in Foxpro
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.
------------------------------------------------------------------------------
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.
