create table common_info( name varchar(10), value int) insert into common_info values('msg_count', 100) 你的sql应该这么写(用存储过程): create proc p_ins_alm_msg @msg_count int out as select @msg_count = value from common_info where name = 'msg_count' update common_info set value = @msg_count+ 1 where name = 'msg_count' and value =
@msg_count if @@rowcount = 0 return -1000 insert into table1 (field0) values(@msg_count) return 0 go
如何判断库中已知表是否存在今日受人之托,帮他解决这个问题,代码为通常的引用Dao做的一模块: Function fExistTable(strTableName As String) As IntegerDim db As DatabaseDim i As Integer Set db = DBEngine.Workspaces(0).Databases(0) fExistTable = False db.TableDefs.Refresh For i = 0 To db.Tabl...