The master helped me look at the SQL statement, thank you

yunshenxin

adoquery1.SQL.Clear;
adoquery1.SQL.Add ('select table1.id as automatic numbering, table1.company as company code, table1.barcode as bar code, table1.liushui as flow code, table1.inout as cargo status, table1.datetime as date from table1 WHERE TABLE1.COMPANY = '"+ edit1.text +"');
adoquery1.ExecSQL;
adoquery1.active: = true;

Why did it report an error?

njy7648

adoquery1.SQL.Add ('select table1.id as automatic numbering, table1.company as company code, table1.barcode as bar code, table1.liushui as flow code, table1.inout as cargo status, table1.datetime as date from table1 WHERE TABLE1.COMPANY = '+ # 39 + edit1.text + # 39);

Also, it ’s better not to use Chinese characters

njy7648

adoquery1.ExecSQL;
Don't say this

yunshenxin

Oh, I want to display Chinese in DBGRID ~~ Do you have any other methods?

njy7648

DBGRID shows Chinese can be directly entered in the column properties