Question

delphi中的sql.add语句

SQL.Add('insert into users(userid,username,password,');
SQL.Add('logindate,rights,comment,sexb,age,cssj,gzsj,');
SQL.Add('department,school,degree,comments)');
SQL.Add('values(:userid,:username,:password,:logindate,');
SQL.Add(':rights,:comment,:sexb,:age,:cssj,:gzsj,');
SQL.Add(':department,:school,:degree,:comments)');
其中values括号中的冒号是干嘛用的？

Answer 1

:password 是参数名

你可以这样定义
ADOQuery.close;
ADOQuery.sql.clear;
ADOQuery.sql.add('select * from table1 where id = :id');
ADOQuery.parambyname('id').asinteger := editid.text;
ADOQuery.Open;