1.sql.Text :='select * from oneflow where flowid = id ';
2.sql.Text :='select * from oneflow where datetime = date ';flowid是整数型,datetime是日期型,id和date是相应类型的变量,这样写在delphi里面好像不对,请教正确的写法?
2.sql.Text :='select * from oneflow where datetime = date ';flowid是整数型,datetime是日期型,id和date是相应类型的变量,这样写在delphi里面好像不对,请教正确的写法?
'select * from oneflow where datetime = '''+datetimetostr(date)+'''';
VAR
vs_dat, vs_id :String;Begin
转换
sql.Text :='select * from oneflow where flowid = ' + vs_id ;
sql.Text :='select * from oneflow where datetime = ' + vs_dat;