insert UserItem(UserItemsetID,UserID,catename,sdate,edate,category,otherdemo,CDemo)
values(@UserItemsetID,@UserID,@catename,@sdate,@edate,@category,@otherdemo,@CDemo)
values(@UserItemsetID,@UserID,@catename,@sdate,@edate,@category,@otherdemo,@CDemo)
insert into agent(id,name,city......)
values (rss("max(id)")+1,trim(name),trim(city)......)
不是全都字符吧
你的id是数字类型的吧
不是数字类型的这样写
sql="insert into agent (id,name,city...) values ('"&rss("max(id)")+1
&"','"&trim(name)&"'.....)"
数字类型的
sql="insert into agent (id,name,city...) values ("&rss("max(id)")+1
&",'"&trim(name)&"'.....)"