×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Selecting "Hidden" records

Selecting "Hidden" records

Selecting "Hidden" records

(OP)
My company uses a software that uses DBF's as the backend database format.  You have the ability to "Hide" records in the program.  When doing queries using ADO they do not show up which is good in most cases.  How do I access the "Hidden" records?  I have not worked with DBF's in such a long time but from what I remember you need to pack the database in order to actually delete the records.  Thanks.

Swi

RE: Selecting "Hidden" records

Swi,

There aren't any hidden records, just records that aren't getting displayed.  The program you use to interface the dbf is limiting the records that are getting displayed.  You can use dbase to browse, list or pack out those records if they were marked for deletion.  But the interface that you use to access the data is the thing that is controlling the records that you can see.   Any utility that can open a dbf file can let you view these records.

Jim C.


RE: Selecting "Hidden" records

(OP)
I would like to access these records that are marked for deletion using ADO.  Is this possible?  Thanks.

Swi

RE: Selecting "Hidden" records

Swi,

I have never used ADO, don't even know what it is.  Is it supposed to allow you to open a DBF file.

Jim C.

RE: Selecting "Hidden" records

(OP)
Yes.  To clarify, I am using VB6 and ADO as the database connection.  Here is the connection.

CODE

Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.CursorLocation = adUseServer
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Path & ";Extended Properties=dBASE 5.0;User ID=;Password="

Swi

RE: Selecting "Hidden" records

to Volker, re  dissapearing records in dbase... I run a small retail store and programmed my own POS system, and I ran into the same problem - I would browse an open .dbf and get "end of file encountered" I then go bott and brow - and the records are there, however they don't stay - when I pack the file they are gone.... I consulted my old Programming teacher and we tried a few tricks until we decided to del the .dbf file and create the same file again " from scratch " - ans siehe da - it worked, maybe it will help you too

RE: Selecting "Hidden" records

kanuck1,

What your talking about is corruption.   I've seen it when browsing files in dbase, but if I switch to FOXPROW it's looks OK.  To clean it up, I'll use FOXPROW to create a delimited file, and then zap the original file, and then append from the delimited file back into the original structure, create a new set of indexes and it's clean going forward.  If it comes back, then something is causing it to reappear.  The end of file marker isn't actually correct, may be two or more end of file markers.

Jim C.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close