help mysql search

[bels79]

I am still learning, and try the example "MYSQL.3".
for input successful but had to search no results.

These pieces of the program, can you please help.

oQuery := oServer:Query( "Select * From Nasabah Where Nopsb = " + Win_1.Text_1.value + " Order By Nopsb" )
msgbox(Win_1.Text_1.value) --> test results are correct
If oQuery:NetErr()
msgbox("message 1")
else
msgbox("message 2")
Endif

thank you,
beni

[Rathinagiri]

Hi

You have to add single quote symbol ' on both sides. Please see and use c2sql function in mysql harbour contrib sample.

[bels79]

tq Rathinagiri

oQuery := oServer:Query( "Select * From Nasabah Where Nopsb = " + c2sql(Win_1.Text_1.value) + " Order By Nopsb" )
mean by adding the command c2sql(Win_1.Text_1.value) ? using c2sql ='12345'
result value oQuery = empty, if found ?

I still do not understand

Hi

You have to add single quote symbol ' on both sides. Please see and use c2sql function in mysql harbour contrib sample.

[Rathinagiri]

It seems your query is correct. Do u get any error?

[bels79]

no error, but the result is always the same (empty), if found or not found
how to display the results "oQuery " ?

Rathinagiri, I am sorry a lot of questions, still need to learn a lot

It seems your query is correct. Do u get any error?

[Rathinagiri]

I think you can make use of hmgmysql library which is based on harbour mysql with three simple functions.

[bels79]

ok tq, I'll try coding a new, hopefully successful

I think you can make use of hmgmysql library which is based on harbour mysql with three simple functions.