Foxpro Deleted Records 
Author Message
 Foxpro Deleted Records

I am using the following code to open a Foxpro database in VB4.0:

Key_Prog.DatabaseName = "c:\iris20\keyw_prg.dbf"
Set keyTable = Key_Prog.Recordset
Key_Prog.Connect = "FoxPro 2.6;"

VB4.0 Help says that Foxpro Deleted records will not be included in
the Recordset if Deleted = True is set at initialization.

Can anyone tell me how and where to specify Deleted = True?

Thanks for your help



Thu, 14 Dec 2000 03:00:00 GMT  
 Foxpro Deleted Records

<snip from VB5 help>

When you install the Microsoft FoxPro database driver, the Setup
program writes a set of default values to the Windows Registry in the
Engines and ISAM Formats subkeys. You should not modify these settings
directly; use the setup program for your application to add, remove,
or change these settings. The following sections describe
initialization and ISAM Format settings for the Microsoft FoxPro
database driver.

Microsoft FoxPro Initialization Settings

The Jet\3.5\Engines\Xbase folder includes initialization settings for
the Msxbse35.dll driver, used for access to external FoxPro data
sources. Typical settings for the entries in this folder are shown in
the following example.

win32=<pathname>\MSXBSE35.dll
NetworkAccess=On
PageTimeout=600
INFPath=C:\DBASE\SYSTEM
CollatingSequence=ASCII
DataCodePage=OEM
Deleted=Off
Century=Off
Date=MDY
Mark=47
Exact=Off

<end snip>

Quote:

>>I am using the following code to open a Foxpro database in VB4.0:

>>Key_Prog.DatabaseName = "c:\iris20\keyw_prg.dbf"
>>Set keyTable = Key_Prog.Recordset
>>Key_Prog.Connect = "FoxPro 2.6;"

>>VB4.0 Help says that Foxpro Deleted records will not be included in
>>the Recordset if Deleted = True is set at initialization.

>>Can anyone tell me how and where to specify Deleted = True?

>>Thanks for your help

                            TRoN~!
                            CompuTec Data Systems


Mon, 18 Dec 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Cannot add record to Visual Foxpro table after deleting all records in table

2. Foxpro database (Deleted Records)

3. deleting records from a Foxpro database

4. Handling A deleted Foxpro Record

5. Cannot delete record on FoxPro 2.5 DB

6. Accessing Foxpro dbf - deleted records

7. Deleted Records Under FoxPro 2.6

8. FoxPro ODBC Driver Shows Deleted Records

9. delete records in Foxpro

10. delete records in foxpro

11. Delete records in foxpro

12. delete a record in FoxPro Table

 

 
Powered by phpBB® Forum Software