Home All Groups Group Topic Archive Search About

Delete records in Dbf table (Help!!!)

Author
13 May 2005 2:21 AM
Junior
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

Author
14 May 2005 7:52 PM
Cindy Winegarden
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


Show quote
"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
Author
14 May 2005 11:41 PM
Junior
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
>
>
>
Author
15 May 2005 1:48 AM
Cindy Winegarden
Hi Junior,

You'll find many more of my answers archived at http://groups.google.com .
It's a great place!

--
Cindy Winegarden  MCSD, Microsoft Visual Foxpro MVP
cindy_winegar***@msn.com  www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden


Show quote
"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:)

AddThis Social Bookmark Button