Hi all
Simple question re .findfirst
Is it true it does not use any indexes and really the best option with
a SQl backend (ignoring using Stored Procedures which at this stage
has not been funded) is to open recordsets with specific SQL to
retreive small recordsets (and EOF indicating .nomatch)
I found a conversion from Access to SQL caused soem of the .FindFirst
calls to become really slow, tabels are indexed correctly. Initial
tests show thta using recordsets where a select command is past seems
to make a nig differance
Cheers
Shaun