SELECT (*) Question

[Swi]

I am using the following code to get the count from a DBF file using VB6 and ADO:

With rs
    .Open "SELECT COUNT(*) FROM [" & FileName & "]", conn, adOpenStatic, adLockReadOnly, adCmdText
    NumOfRecords = .Fields(0).Value
    .Close
End With

It seems to return the correct count when the DBF is small but if it is large it does not return the correct number. Any ideas? Thanks.

Swi

 

[cricket]

Have you a TRIM() function in your index or any variiant of TRIM (RTRIM(),ALLTRIM())

If so, this is a problem, as the index depth is only that of the trimmed first record

 

[Swi]

I don't think so but I will check.

Swi

 

[Swi]

I checked and there is no function on the index. Any other ideas? Thanks.

Swi

 

[JCreamerII]

Swi,

If you just doing a count, why open the index? Try it without the index and see if you get the same result.

 

[Swi]

Can you provide an example using ADO?

Swi