What's wrong with SQLSelect?

[Ruslan Zasukhin]

On 3/29/05 6:36 AM, "Kem Tekinay" <ktekinay at mactechnologies.com> wrote:

> I have a zip code database on which I use the following RB code:
> 
>   if find = "" then
>     sql = "SELECT * FROM Zip_Codes"
>   else
>     sql = "SELECT * FROM Zip_Codes WHERE " + _
>         "Zip_Code LIKE '" + find + "%' " + _
>         "OR City LIKE '" + find + "%' " + _
>         "OR State LIKE '" + find +"%'"
>   end if
>   
>   try
>     curs = gDB.SQLSelect( sql, EVCursorLocation.kClientSide,
> EVLockType.kReadOnly, EVCursorDirection.kForwardOnly )
>   catch err as VException
>     MsgBox gDB.ErrString
>   end try
>   
> The problem is, while the search is fine when I use a zip code value, it
> fails when I use a value found in City or State (both indexed). The same
> search works fine in the REALdatabase.

I am sorry I have not understand where is problem.

Search is fine, BUT ?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]