sqlce error

hi,
i use sqlce and .net for pocketpc(symbol mc3000)

my code is
SQL_text = "WHERE product_name LIKE ‘%" &
Txtproductname.Text.Trim & "%’ "

and i have this error

[-->product.SQLDS<--]select * from product where product_name
like '%cd%'
system.Data.SqlServerCe.SqlCeException

whats wrong

thanks regards

have u tried this in the query analyser in the emulator or device.

The exception you have shown makes no sense. I have never seen anything like it.

Add a try catch around your code so you can see the exact exception.

eg
try
Dim l_sqlstmt As String = "SELECT * FROM Product Where product_name LIKE '%cd%'

......

catch ex as sqlceexception
msgbox ex.message
end try

what exception is thrown.

You are probably better of to post your code for this so we can see where the problem lies. Also note the line the exception is thrown on

hi all,

its done.
its working.
its stupid think maybe but working
SQL = "where product_name like '%%'"
SQL = SQL.Insert(27, Txtproduct_name.Text.ToString)

thanks all.