是这样的,数据库有一字段roomym为money类型,现在该在下面括号处填上什么?var
SQLString:String;
e5:double;
begin
e5:=(怎么填);
.............
with ADOQuery1 do
SQLString:='insert into binke(......,roomym) values(........,(怎么填))';
.................
end.
各位高手,凡是能够运行并得出正确结果的前4名者均可或20分,剩20分给发表的各位!
SQLString:String;
e5:double;
begin
e5:=(怎么填);
.............
with ADOQuery1 do
SQLString:='insert into binke(......,roomym) values(........,(怎么填))';
.................
end.
各位高手,凡是能够运行并得出正确结果的前4名者均可或20分,剩20分给发表的各位!
如roomym是字符类型
.............
with ADOQuery1 do
SQLString:='insert into binke(......,roomym) values(........,(50))';
.............
with ADOQuery1 do
SQLString:='insert into binke(......,roomym)
values(........,'+e5+')';
SQLString:='insert into binke(......,roomym)
values(........,'''+e5+''')';
edit1.text通过类型转化给e5啊,或者有什么其他办法啊!
SQLString:String;
e5:currency;
begin
e5:=StrToCurr(Edit1.text);
.............
with ADOQuery1 do
SQLString:=Format('insert into binke(......,roomym) values(........,%s),[e5])';
.................
end.
说明:
e5:currency;--把定义成e5定义成currency货币类型e5:=StrToCurr(Edit1.text);--把输入在Edit1.text中的文本数据转换成货币类型
SQLString:=Format('insert into binke(......,roomym) values(........,%s),[e5])'; --用Format()函数格式化字符串,并用e5做为变量