sql - Cant find column but it exist -


hi im working on delphi 10 , sybase.

im having issue 2 days ago , i've tried lot of things. set adoconnection properties in build, searh db , ready. can insert,delete , update when im trying make select x y z output column y not found

when :

select * administradores  

it work,but 1 need dont. code one.

adoquery1.close ; adoquery1.sql.clear; adoquery1.sql.text:='select usu_administrador,pass_administrador administradores  usu_administrador='+edit1.text+''; adoquery1.open; 

i tried sql syntax error ,open fields editor , dont have fields. post happen me, solution didnt work me.

please,could me?

you should use parameters in queries

adoquery1.sql.text:='select usu_administrador, pass_administrador ' +       ' administradores  usu_administrador = :paramadminname'; adoquery1.parambyname('paramadminname').value := edit1.text; 

also, reason why query didn't work value in edit1 must in quotes work in sql

adoquery1.sql.text:='select usu_administrador,pass_administrador administradores  usu_administrador='+quotedstr(edit1.text); 

Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -