RE: Boolean fields in Foxpro
Drop me a line anytime. You can do it via the list, or if you wish e-mail [EMAIL PROTECTED] If I can help your programmer with any of the FoxPro stuff I'll be glad to try. At 08:15 AM 5/17/2000 -0400, you wrote: >Date: Wed, 17 May 2000 08:35:40 +0100 >From: Michael O Reilly <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: RE: Boolean fields in Foxpro >Message-ID: <ECE6504EA487D3118D8A00805F59102E7EB2F6@NT_BACKUP> > >Bill, >That looks like it should be a great help. The Foxpro stuff doesn't mean >much to me, but I'll pass it on to the Foxpro programmer from the company >I'm working for. >There's a Tag in Nate's Tag gallery call CF_Waitfor which will wait for >certain condition's to be true before continuing. >When (if) I get the database packed, I can trigger one of said conditions. > >Can I get back to you if I need any further assistance? In the meantime, >enjoy the vacation. > >Regards >Michael O'Reilly >Analyst Programmer >TransAer > Bill Grover Supervisor, IS EU Services, Inc. 649 N Horners Ln Rockville MD 20850 Phone: 301-424-3300 x396 FAX:301-424-3300 x1396# E-Mail: [EMAIL PROTECTED] -- 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.
RE: Boolean fields in Foxpro
Bill, That looks like it should be a great help. The Foxpro stuff doesn't mean much to me, but I'll pass it on to the Foxpro programmer from the company I'm working for. There's a Tag in Nate's Tag gallery call CF_Waitfor which will wait for certain condition's to be true before continuing. When (if) I get the database packed, I can trigger one of said conditions. Can I get back to you if I need any further assistance? In the meantime, enjoy the vacation. Regards Michael O'Reilly Analyst Programmer TransAer -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED]] Sent: 16 May 2000 19:26 To: [EMAIL PROTECTED] Subject: RE: Boolean fields in Foxpro I don't see why not. To be honest I've never tried to execute an external application from CF. One item I'm not sure of is if CF will wait for the application to finish. If it does then I'd run with it. Another way to accomplish this that should work as well would be to do the following. 1. Create a FoxPro program that ends up being a COM object. 2. In CF use the CFLock. 3. Create your object using CFOBJECT 4. Call a method on the object that does the pack. 5. Release the object 6. Release the CFLock. The following code snippet should give you the basics of the COM object code. This snippet needs to be placed in a program (.prg) and set as the main program of your project. Then build your project when building the project you need to tell it to create a Win32 executeable/COM Server. Also tell it to Regenerate Component ID's. I've had my best success with FoxPro COM objects this way. DEFINE CLASS MyPack AS custom OLEPUBLIC PROCEDURE DoPack * * Here is where the code goes to pack your database * OPEN DATABASE myDatabase&& Open your database SELECT 0&& Select the next available workspace USE table1 EXCLUSIVE&& Open your table, it will become the selected table. PACK&& Pack the table just opened USE && Close the table just packed. SELECT 0&& Select the next available workspace. USE table2 EXCLUSIVE&& Open your table, it will become the selected table. PACK&& Pack the table just opened. USE && Close the table just packed. RETURN ENDPROC ENDDEFINE Let me know if I can be of any more help. Bill Grover Supervisor, IS EU Services, Inc. 649 N Horners Ln Rockville MD 20850 Phone: 301-424-3300 x396 FAX:301-424-3300 x1396# E-Mail: [EMAIL PROTECTED] At 12:15 PM 5/16/2000 +0000, you wrote: >Date: Tue, 16 May 2000 09:21:19 +0100 >From: Michael O Reilly <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: RE: Boolean fields in Foxpro >Message-ID: <ECE6504EA487D3118D8A00805F59102E7EB2D1@NT_BACKUP> > >Bill, >Don't worry about speed of reply's. I find that I don't have time to read >even a quarter of the stuff on this list. I wouldn't expect somebody to use >their vacation time to reply to post's. >Any reply's I receive are a bonus. >Anyway Foxpro. >I discovered last night the issue about requiring exclusive use of the DB to >perform a PACK. >I records marked as deleted are not retrieved by SQL queries but they stay >in the DB. >I reckon some of the tables were planning to use will get pretty large so I >had to get rid of these redundant records. > >Could I schedule a template to run at Midnight on Sunday which perform's a >CFLock and then executes an external app which pack's the DB? > >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.
RE: Boolean fields in Foxpro
I don't see why not. To be honest I've never tried to execute an external application from CF. One item I'm not sure of is if CF will wait for the application to finish. If it does then I'd run with it. Another way to accomplish this that should work as well would be to do the following. 1. Create a FoxPro program that ends up being a COM object. 2. In CF use the CFLock. 3. Create your object using CFOBJECT 4. Call a method on the object that does the pack. 5. Release the object 6. Release the CFLock. The following code snippet should give you the basics of the COM object code. This snippet needs to be placed in a program (.prg) and set as the main program of your project. Then build your project when building the project you need to tell it to create a Win32 executeable/COM Server. Also tell it to Regenerate Component ID's. I've had my best success with FoxPro COM objects this way. DEFINE CLASS MyPack AS custom OLEPUBLIC PROCEDURE DoPack * * Here is where the code goes to pack your database * OPEN DATABASE myDatabase&& Open your database SELECT 0&& Select the next available workspace USE table1 EXCLUSIVE&& Open your table, it will become the selected table. PACK&& Pack the table just opened USE && Close the table just packed. SELECT 0&& Select the next available workspace. USE table2 EXCLUSIVE&& Open your table, it will become the selected table. PACK&& Pack the table just opened. USE && Close the table just packed. RETURN ENDPROC ENDDEFINE Let me know if I can be of any more help. Bill Grover Supervisor, IS EU Services, Inc. 649 N Horners Ln Rockville MD 20850 Phone: 301-424-3300 x396 FAX:301-424-3300 x1396# E-Mail: [EMAIL PROTECTED] At 12:15 PM 5/16/2000 +, you wrote: >Date: Tue, 16 May 2000 09:21:19 +0100 >From: Michael O Reilly <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: RE: Boolean fields in Foxpro >Message-ID: <ECE6504EA487D3118D8A00805F59102E7EB2D1@NT_BACKUP> > >Bill, >Don't worry about speed of reply's. I find that I don't have time to read >even a quarter of the stuff on this list. I wouldn't expect somebody to use >their vacation time to reply to post's. >Any reply's I receive are a bonus. >Anyway Foxpro. >I discovered last night the issue about requiring exclusive use of the DB to >perform a PACK. >I records marked as deleted are not retrieved by SQL queries but they stay >in the DB. >I reckon some of the tables were planning to use will get pretty large so I >had to get rid of these redundant records. > >Could I schedule a template to run at Midnight on Sunday which perform's a >CFLock and then executes an external app which pack's the DB? > >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.
RE: Boolean fields in Foxpro
The VFP ODBC driver also has a setting that will allow you to ignore deleted records. That would be easier and if you add an index tag on DELETED(), it's optimizable too! ;-) Larry >>> [EMAIL PROTECTED] 05/15/00 03:43PM >>> Michael, Not a problem getting back. I have never tried to do a pack via ODBC. Pack is a native FoxPro command and as such I don't believe you can do it from the ODBC driver. It sounds like in order to physically remove the records you will need to write a FoxPro program that will pack the database for you. BTW, to do a pack you will need exclusive use of the table(s). So part of this process will be to insure that everyone is out of the database before doing the pack, or it will fail. Are you having problems when the records are deleted having them retrieved? The way we deal with this is to have a field in the record that marks the record as "deleted" without relying on FoxPro's deleted flag. Usually we use a DateTime field like tablename_deleted_datetime. The default value of this field is NULL and when we want to delete the record we store the current datetime in the field. Then when we select records we add 'AND ISNULL(table_deleted_datetime)' to the where clause to filter these records. Make sure to set an index on the table for this field so your query is Rushmore Optimizable. FYI, if it appears that my responses are a bit slow I appologize. I'm on vacation from 5/15 until 5/30 but, as you can tell, I do check my E-Mail once a day. Also I only get the digest version so depending on when the CF-Talk is delivered and I check mail will dictate when I reply. Talk to you soon. Bill Grover Supervisor, IS EU Services, Inc. 649 N Horners Ln Rockville MD 20850 Phone: 301-424-3300 x396 FAX:301-424-3300 x1396# E-Mail: [EMAIL PROTECTED] Original Message Date: Mon, 15 May 2000 15:51:53 +0100 From: Michael O Reilly <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: RE: Boolean fields in Foxpro Message-ID: <ECE6504EA487D3118D8A00805F59102E7EB2BA@NT_BACKUP> 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 -- 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?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Boolean fields in Foxpro
Bill, Don't worry about speed of reply's. I find that I don't have time to read even a quarter of the stuff on this list. I wouldn't expect somebody to use their vacation time to reply to post's. Any reply's I receive are a bonus. Anyway Foxpro. I discovered last night the issue about requiring exclusive use of the DB to perform a PACK. I records marked as deleted are not retrieved by SQL queries but they stay in the DB. I reckon some of the tables were planning to use will get pretty large so I had to get rid of these redundant records. Could I schedule a template to run at Midnight on Sunday which perform's a CFLock and then executes an external app which pack's the DB? Regards Michael O'Reilly Analyst Programmer TransAer -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED]] Sent: 15 May 2000 22:44 To: [EMAIL PROTECTED] Subject: RE: Boolean fields in Foxpro Michael, Not a problem getting back. I have never tried to do a pack via ODBC. Pack is a native FoxPro command and as such I don't believe you can do it from the ODBC driver. It sounds like in order to physically remove the records you will need to write a FoxPro program that will pack the database for you. BTW, to do a pack you will need exclusive use of the table(s). So part of this process will be to insure that everyone is out of the database before doing the pack, or it will fail. Are you having problems when the records are deleted having them retrieved? The way we deal with this is to have a field in the record that marks the record as "deleted" without relying on FoxPro's deleted flag. Usually we use a DateTime field like tablename_deleted_datetime. The default value of this field is NULL and when we want to delete the record we store the current datetime in the field. Then when we select records we add 'AND ISNULL(table_deleted_datetime)' to the where clause to filter these records. Make sure to set an index on the table for this field so your query is Rushmore Optimizable. FYI, if it appears that my responses are a bit slow I appologize. I'm on vacation from 5/15 until 5/30 but, as you can tell, I do check my E-Mail once a day. Also I only get the digest version so depending on when the CF-Talk is delivered and I check mail will dictate when I reply. Talk to you soon. Bill Grover Supervisor, IS EU Services, Inc. 649 N Horners Ln Rockville MD 20850 Phone: 301-424-3300 x396 FAX:301-424-3300 x1396# E-Mail: [EMAIL PROTECTED] Original Message Date: Mon, 15 May 2000 15:51:53 +0100 From: Michael O Reilly <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: RE: Boolean fields in Foxpro Message-ID: <ECE6504EA487D3118D8A00805F59102E7EB2BA@NT_BACKUP> 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 -- 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.
RE: Boolean fields in Foxpro
Michael, Not a problem getting back. I have never tried to do a pack via ODBC. Pack is a native FoxPro command and as such I don't believe you can do it from the ODBC driver. It sounds like in order to physically remove the records you will need to write a FoxPro program that will pack the database for you. BTW, to do a pack you will need exclusive use of the table(s). So part of this process will be to insure that everyone is out of the database before doing the pack, or it will fail. Are you having problems when the records are deleted having them retrieved? The way we deal with this is to have a field in the record that marks the record as "deleted" without relying on FoxPro's deleted flag. Usually we use a DateTime field like tablename_deleted_datetime. The default value of this field is NULL and when we want to delete the record we store the current datetime in the field. Then when we select records we add 'AND ISNULL(table_deleted_datetime)' to the where clause to filter these records. Make sure to set an index on the table for this field so your query is Rushmore Optimizable. FYI, if it appears that my responses are a bit slow I appologize. I'm on vacation from 5/15 until 5/30 but, as you can tell, I do check my E-Mail once a day. Also I only get the digest version so depending on when the CF-Talk is delivered and I check mail will dictate when I reply. Talk to you soon. Bill Grover Supervisor, IS EU Services, Inc. 649 N Horners Ln Rockville MD 20850 Phone: 301-424-3300 x396 FAX:301-424-3300 x1396# E-Mail: [EMAIL PROTECTED] Original Message Date: Mon, 15 May 2000 15:51:53 +0100 From: Michael O Reilly <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: RE: Boolean fields in Foxpro Message-ID: <ECE6504EA487D3118D8A00805F59102E7EB2BA@NT_BACKUP> 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 -- 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.
RE: Boolean fields in Foxpro
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 IN 0 SELECT LIST STRUCTURE NOCONSOLE TO FILE 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 TypeWidthDec Index Collate Nulls 1 CUSTNO Character 6 No 2 CHECKNO Character 6 No 3 TRANSDATE Date8 No 4 PAYEE Character 40 No 5 AMOUNT Numeric 9 2 No 6 JOBNO Character 6 No 7 TYPECharacter 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 DepartmentPhone: 301.424.3300 x396 EU Services, Inc. FAX: 301.424.3300 x1396# 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] Rockville, MD 20850-1299WWW: 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.
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 IN 0 SELECT LIST STRUCTURE NOCONSOLE TO FILE 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 TypeWidthDec Index Collate Nulls 1 CUSTNO Character 6 No 2 CHECKNO Character 6 No 3 TRANSDATE Date8 No 4 PAYEE Character 40 No 5 AMOUNT Numeric 9 2 No 6 JOBNO Character 6 No 7 TYPECharacter 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 DepartmentPhone: 301.424.3300 x396 EU Services, Inc. FAX: 301.424.3300 x1396# 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] Rockville, MD 20850-1299WWW: 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.
RE: Boolean fields in Foxpro
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 -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED]] Sent: 10 May 2000 13:46 To: '[EMAIL PROTECTED]' Subject: RE: Boolean fields in Foxpro 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 DepartmentPhone: 301.424.3300 x396 EU Services, Inc. FAX: 301.424.3300 x1396# 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] Rockville, MD 20850-1299WWW: 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. > > INSERT INTO Tablename (BooleanField) VALUES (.T.) > > > 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. -- 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.
RE: Boolean fields in Foxpro
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 DepartmentPhone: 301.424.3300 x396 EU Services, Inc. FAX: 301.424.3300 x1396# 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] Rockville, MD 20850-1299WWW: 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. > > INSERT INTO Tablename (BooleanField) VALUES (.T.) > > > 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.
RE: Boolean fields in Foxpro
Larry, Thanks for the reply, apologies for not getting back sooner. INSERT INTO Tablename (BooleanField) VALUES (.T.) 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. -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED]] Sent: 09 May 2000 16:03 To: [EMAIL PROTECTED] Subject: RE: Boolean fields in Foxpro I know this works: INSERT INTO Tablename (BooleanField) VALUES (.T.) Larry >>> [EMAIL PROTECTED] 05/09/00 01:50AM >>> I can't believe that this is causing me so much grief. Last night I tried the following INSERT INTO (Tablename.BooleanField) VALUES ('.T.') I also tried VALUES (.T.) VALUES ('T') VALUES (T) VALUES ('#.T.#') and none of these work. -- 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.
RE: Boolean fields in Foxpro
I know this works: INSERT INTO Tablename (BooleanField) VALUES (.T.) Larry >>> [EMAIL PROTECTED] 05/09/00 01:50AM >>> I can't believe that this is causing me so much grief. Last night I tried the following INSERT INTO (Tablename.BooleanField) VALUES ('.T.') I also tried VALUES (.T.) VALUES ('T') VALUES (T) VALUES ('#.T.#') and none of these work. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Boolean fields in Foxpro
I can't believe that this is causing me so much grief. Last night I tried the following INSERT INTO (Tablename.BooleanField) VALUES ('.T.') 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 UPDATE Tablename SET Tablename.BooleanField = 0 WHERE Tablename.CompanyID = 5 or UPDATE Tablename SET Tablename.BooleanField = 1 WHERE Tablename.CompanyID = 5 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 DepartmentPhone: 301.424.3300 x396 EU Services, Inc. FAX: 301.424.3300 x1396# 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] Rockville, MD 20850-1299WWW: 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 > -- 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.
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 DepartmentPhone: 301.424.3300 x396 EU Services, Inc. FAX: 301.424.3300 x1396# 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] Rockville, MD 20850-1299WWW: 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 > -- 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.
RE: Boolean fields in Foxpro
Thanks for the help, much appreciated. I'll try '.T.' I remember that notation from my DBaseIV days. Regards Michael O'Reilly TransAer -Original Message- From: Randy Adkins [mailto:[EMAIL PROTECTED]] Sent: 08 May 2000 10:43 To: [EMAIL PROTECTED] Subject: Re: Boolean fields in Foxpro 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 - > > > > > > > > > INSERT INTO (Tablename.BooleanField) > > > VALUES ('0') > > > > > > > > > - 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
Re: Boolean fields in Foxpro
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 - > > > > > > > > > INSERT INTO (Tablename.BooleanField) > > > VALUES ('0') > > > > > > > > > - 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.
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 - > > > > > > INSERT INTO (Tablename.BooleanField) > > VALUES ('0') > > > > > > - 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.
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 - > > > > > > INSERT INTO (Tablename.BooleanField) > > VALUES ('0') > > > > > > - 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.
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 - > > > INSERT INTO (Tablename.BooleanField) > VALUES ('0') > > > - 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.
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 - > > > INSERT INTO (Tablename.BooleanField) > VALUES ('0') > > > - 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.
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 - INSERT INTO (Tablename.BooleanField) VALUES ('0') - 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.