
Foxpro database (Deleted Records)
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