网格问题

Question

sql.text:='delete students where stuno=''+dbgrid1.Columns0).text+''';
execsql;怎么不认识里面的dbgrid1.Columns0).text　是不是语句有问题啊

Answer 1

我想应该是dbgrid1.columns[0].text

Answer 2

是啊,你的引号好象有问题.多试试吧.加深记忆.
sql.text:='delete students where tuno='+''''+dbgrid1.Columns0).text+'''';sql.text:='delete students where tuno="'+dbgrid1.Columns[0].text+'"';

Answer 3

这个行吗
sql.text:='delete students where stuno=+'''+dbgrid1.Columns(0).text+'''';

Answer 4

sql.text:='delete students where tuno='+ a1.FieldByName(DBGrid1.Columns[2].Fieldname).AsString;
Execsql;