Hi! I am new to database programming, and am trying to read a database file
I have read it just great!! and everything was working out fine, untill i
realized
my program cant distinguish between normal records, and records marked for
deletion, Anyone know what commands are used to return true/false as to if a
record is
marked for deletion?  This is the function i use to get data from a
table/dbf
**********************************
Private Function GetData(sTable As String)
    Dim sSQL As String
    Dim sData As String
    Dim i As Integer
    Dim sta As String 'string to add
    sSQL = "Select * from " & sTable
    Set rs = DB.OpenRecordset(sSQL)
    With rs
        Do While Not .EOF
           dblist.AddItem .Fields(1)
            .MoveNext
        Loop
        .Close
   End With
End Function
**********************************
Thanks for any help!!!!

JoeB

I vaguely remember something about a magic "DELETED=ON" setting within
DBEngine or maybe Workspace if you're using DAO.

--

WARNING: I cannot be held responsible for the above        They're   coming  to
because  my cats have  apparently  learned to type.        take me away, ha ha!