To All
I am trying to put together a Sql statement that uses two varibles .. Here is an example
want to find 1234 MAIN
cADDRESS := "12 "
cSTREET := "M "
cSQL := "Select * from PROPERTY where ADDRESS like '"+alltrim(cADDRESS)+"%' and STREET like '"+alltrim(cSTREET)+"%'"
or on a Recordset already open
oRs:Find := ("ADDRESS like '"+alltrim(cADDRESS)+"%'" and STREET like '"+alltrim(cSTREET)+"%'"
Any Ideas ??
Thanks
Rick Lipkin
Hello
what error do you get?
your way work for me
Rick,
i tried
SELECT * FROM empleados WHERE calle like '%JUAN%' and numero like '%12%'
or
cCalle = 'JUAN'
nNum = STR(12,2)
SELECT * FROM empledos WHERE calle like "'%" + cCalle + "%'" and numero like"'%" +cNum + "%'"
and result is ok
regards
pak.o
Sorry,
other option
cCampo := "CONCAT(paterno, ' ', materno, ' ', nombre)"
cFiltro := "FRAN"
SELECT *,CONCAT(paterno, ' ', materno, ' ', nombre) AS completo FROM empleados " +;
" WHERE "+cCampo+" LIKE '%" + ALLTRIM(cFiltro) + "%'"
Regards
Pak.o
Gentlemen
Thanks for your input .. I tested my code on an Access database some time back and recall I had issues .. I am re-visiting this code today and will be reviewing the results ..
Thanks
Rick Lipkin
ADO Find does not support AND.
Your sql where clause for reading from table is okay and you should not have any problem.
