
Seek sometimes doesn't match record
Hi !
I wrote an application in VB4 16 bit in a Windows 3.11 for Workgroup
environment.
This application runs on only 2 PCs : one is the server and the other is
the client.
I have a Table, called "SCADENZE" with those fields :
CODE Text 13
YEAR Integer
MONTH Integer
QUANTITY Double
and a Index, called "ISCAD" with this structure :
CODE Descend
YEAR Descend
MONTH Descend
Then I have this code :
Set TBART = DBART.OpenRecordset("SCADENZE", dbOpenTable)
TBART.LockEdits = False
If Not TBART.EOF Then TBART.MoveLast
If TBART.RecordCount > 0 Then
TBART.MoveFirst
TBART.Index = "ISCAD"
TBART.Seek ">=", xcar, 1, 1
If Not TBART.NoMatch Then
..................
Else
..................
End If
End If
End If
DBART.Close
Well....sometimes the seek doesn't find the records, even if they are in
the table.
Is there someone that had a similar problem and can help me ?
Thanks a lot !!!
Ugo Marconetto - Smart
Via Valoria Inferiore, 18
12037 SALUZZO (CN) ITALY
Tel. +39 0336 581079
Fax. +39 0175 248909