|
code
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Delete records in Dbf table (Help!!!)I am developing Visual Basic 6.0 application using ADO 2.5 and tables of
Dbase III. When i delete the record the database engine marks it as deleted but, the record is not deleted phisical, in Fox i have instructions as Pack or Zap for deleted the record, but i don't have them in Ado. What can i do? Its posible use cdx index of Dbase III with Visual Basic 6.0.? Thankz Hi Junior,
I've never worked with DBase III but... Why do you feel you need to physically delete the record from the file? Most FoxPro programs (and I assume DBase III) are written to ignore deleted records. Packing the tables is a maintenance issue and not usually done on an immediate basis. The following article shows how to pack tables via ODBC: "HOWTO: Pack a Table Through the Visual FoxPro ODBC Driver (VFPODBC.dll) ", http://support.microsoft.com/?kbid=234756 Visual FoxPro is a very backward-compatible development tool and would be backwardly compatible with all previous versions of tables, and I assume the same applies to DBase III tables. You should be able to use the CDX indexes. -- Show quoteCindy Winegarden MCSD, Microsoft Visual Foxpro MVP cindy_winegar***@msn.com www.cindywinegarden.com Blog: http://spaces.msn.com/members/cindywinegarden "Junior" <Jun***@discussions.microsoft.com> wrote in message news:34D98FC6-48D6-498C-8667-8BD812F86E5E@microsoft.com... >I am developing Visual Basic 6.0 application using ADO 2.5 and tables of > Dbase III. > > When i delete the record the database engine marks it as deleted but, the > record is not deleted phisical, in Fox i have instructions as Pack or Zap > for > deleted the record, but i don't have them in Ado. > > What can i do? > > Its posible use cdx index of Dbase III with Visual Basic 6.0.? > > Thankz A friend send me a link with a excelent answer
http://www.codecomments.com/message374801.html Your answer, Thank you:) Show quote "Cindy Winegarden" wrote: > Hi Junior, > > I've never worked with DBase III but... > > Why do you feel you need to physically delete the record from the file? Most > FoxPro programs (and I assume DBase III) are written to ignore deleted > records. Packing the tables is a maintenance issue and not usually done on > an immediate basis. > > The following article shows how to pack tables via ODBC: "HOWTO: Pack a > Table Through the Visual FoxPro ODBC Driver (VFPODBC.dll) ", > http://support.microsoft.com/?Âkbid=234756 > > > Visual FoxPro is a very backward-compatible development tool and would be > backwardly compatible with all previous versions of tables, and I assume the > same applies to DBase III tables. You should be able to use the CDX indexes. > > > -- > Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP > cindy_winegar***@msn.com www.cindywinegarden.com > Blog: http://spaces.msn.com/members/cindywinegarden > > > "Junior" <Jun***@discussions.microsoft.com> wrote in message > news:34D98FC6-48D6-498C-8667-8BD812F86E5E@microsoft.com... > >I am developing Visual Basic 6.0 application using ADO 2.5 and tables of > > Dbase III. > > > > When i delete the record the database engine marks it as deleted but, the > > record is not deleted phisical, in Fox i have instructions as Pack or Zap > > for > > deleted the record, but i don't have them in Ado. > > > > What can i do? > > > > Its posible use cdx index of Dbase III with Visual Basic 6.0.? > > > > Thankz > > > Hi Junior,
You'll find many more of my answers archived at http://groups.google.com . It's a great place! -- Show quoteCindy Winegarden MCSD, Microsoft Visual Foxpro MVP cindy_winegar***@msn.com www.cindywinegarden.com Blog: http://spaces.msn.com/members/cindywinegarden "Junior" <Jun***@discussions.microsoft.com> wrote in message news:5C4C652A-2086-4054-8E36-CFA92114F2DE@microsoft.com... >A friend send me a link with a excelent answer > > http://www.codecomments.com/message374801.html > > Your answer, Thank you:)
Other interesting topics
|
|||||||||||||||||||||||