Seek sometimes doesn't match record 
Author Message
 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



Tue, 02 Nov 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. sometimes he does it sometimes he doesn't

2. Seek Nearest Match if exact match not found ?

3. Seek Nearest Match if exact match not found ?

4. Email text doesn't appear in sent items (sometimes)

5. Button.Focus() method doesn't work (sometimes)

6. ActiveX call (VB to Matlab) executed but doesn't return...sometimes

7. TableDefs.Delete doesn't work sometimes

8. Event procedure doesn't match definition

9. Match in DataCombo doesn't work properly

10. Crystal DON'T show the last record (sometimes), reprinting DO

11. 2 questions: Code doesn't work when I split database and Seek/Index question

12. Finding records that don't match

 

 
Powered by phpBB® Forum Software