关于往数据库中插入数据的问题:
数据库中建了一张借款表:
CREATE TABLE [dbo].[borrowmoneylable] (
[number] [int] IDENTITY (1000, 1) NOT NULL ,
[name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[borrowmoney] [decimal](10, 0) NOT NULL ,
[allowperson] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[used] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[yn] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[person] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[regdate] [datetime] NOT NULL
) ON [PRIMARY]
GO
在pb中设计的窗体界面中插入数据,点击“确定”后总是说“访问数据库出错”。
看下面的代码。我看不出哪有错啊?
dec bor
string na,al,us
date reg
reg=today()
bor=dec(em_bormen.text)
na=sle_bormen.text
al=sle_allmen.text
us=mle_use.text
if em_bormen.text="" then
messagebox("系统提示","请输入借款金额!",information!,ok!)
em_bormen.setfocus()
return
end if
if sle_bormen.text="" then
messagebox("系统提示","请输入借款人名称!",information!,ok!)
sle_bormen.setfocus()
return
end if
if sle_bormen.text="" then
messagebox("系统提示","请输入批准人名称!",information!,ok!)
sle_allmen.setfocus()
return
end if
COMMIT USING SQLCA;
INSERT INTO borrowmoneylable(name,borrowmoney,allowperson,used,yn,person,regdate)
VALUES (:na,:bor,:al,:us,"Y",:sysopname,:reg)
USING SQLCA;
if sqlca.Sqlcode = -1 then
ROLLBACK USING SQLCA;
messagebox("访问数据库错误",SQLca.SqlErrtext)
else
COMMIT USING SQLCA;
sle_bormen.text =""
sle_allmen.text = ""
mle_use.text = ""
em_bormen.text=""
em_bormen.setfocus()
end if
想请大家帮我一下。哪地方不对?
谢谢!