ODBC problem

[yagnik3128]

I am developing network applications.

I am using ODBC for MS Access database & ADO.

My coding sequence is

dim Sql as string
dim RsSql as new adodb.recordset

sql = "Select * from Group Where GroupCode like '" & txtgroup & "%' order by GroupDescr"

rssql.open sql,MyConn, adopenkeyset, adlockoptimistic,

But the query is very slow.

If I use provider 4.0 & * instead of % in a select statement, it is very fast.

Is there any solution to use % & ADO & DSN (ODBC) very fast.

 

[rtshort]

I'm not sure but you can try putting another % sign in your query.

sql = "Select * from Group Where GroupCode like '%" & txtgroup & "%'"

The % sign tells SQL that the statement is not a complete word and to look for matching letters. If the % sign is left off of the front (which may be what you need, sorry if it is) then SQL thinks that you are looking for a word starting with "txtgroup" with the ending of the word not complete.

Example: searching for Betty

'%tty' tells SQL that the statement ends with "tty"

'Bet%' tells SQL that the statement starts with "Bet"

'%ett%' tells SQL that the satement has "ett" in the middle.

If you know the word is equal to what you're lookin for then you can state:

sql = "Select * from Group Where GroupCode ='" & txtgroup & "'"

Hope this is what you were looking for.

Every day above ground is a GOOD DAY!!!