这是数据库插入数据程序:
var
querystr1:string;
g_mingcheng:string;
g_bianhao:integer;
begin
g_bianhao:=strtoint(edit5.text);
g_mingcheng:=edit6.text;
sqlbumen0.Close;
queryStr1 := 'insert into gonganbumen'+
'(g_bianhao,g_mingcheng )'+
'values("'+
inttostr(g_bianhao) +'","'+
g_mingcheng +'")';
运行的时候出现这样的错误:这个g_bianhao:=strtoint(edit5.text)是“is not a valid integer value"为什么?我已经把edit5的内容做转换了?为什么会这样?
var
querystr1:string;
g_mingcheng:string;
g_bianhao:integer;
begin
g_bianhao:=strtoint(edit5.text);
g_mingcheng:=edit6.text;
sqlbumen0.Close;
queryStr1 := 'insert into gonganbumen'+
'(g_bianhao,g_mingcheng )'+
'values("'+
inttostr(g_bianhao) +'","'+
g_mingcheng +'")';
运行的时候出现这样的错误:这个g_bianhao:=strtoint(edit5.text)是“is not a valid integer value"为什么?我已经把edit5的内容做转换了?为什么会这样?
'(g_bianhao,g_mingcheng )'+
'values('+
inttostr(g_bianhao) +',"'+
g_mingcheng +'")';
queryStr1 := 'insert into gonganbumen'+
'(g_bianhao,g_mingcheng )'+
'values('+
g_bianhao +',"'+
g_mingcheng +'")';
'(g_bianhao,g_mingcheng )'+
'values('+
g_bianhao +',"'+
g_mingcheng +'")';
再看
呵呵
还不用转换类型
你转换的时候,最好加抛出异常语句
try
g_bianhao:=strtoint(edit5.text);
except
ShowMessage(输入的不是数字);
exit;
end;