Don't use Like...
I think is better to use the 'where' clause
for example:
select * from database where name='" & text1.text & "'"
'bind the data retrived and then use this:
if (datasource.recordset.bof) and (datasoucr.recordset.eof) then 'BOF and EOF true = no record in the...
whe u are geting all the records are you binding imidiatly the recordset????? some controls make the binding very slow!!! if u dont need to see all the records at same time, u can use 2 method's.
1st - select [indexed_field] >>>> only the indexed in one 'datadource' then u can move the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.