2,496
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
wfmwg 2001-01-11
- 打赏
- 举报
你用触发器不就行了？
Hibin 2000-06-22
- 打赏
- 举报
我的经验是：保存原始记录，（货号，进货量），库存量不在原始记录表中保存，需要是通过SQL查询获得，查询语句如 jansenzhu所述。或者用SQL查询生成库存量的临时表：
select ... group by ... into TempTableName
select ... group by ... into TempTableName
Limu 2000-06-21
- 打赏
- 举报
Use this SQL Statement:
Update tablename Set StoreNumber=StoreNumber+ExtraNumber Where condition.
here tablename is your table name. StoreNumber is the repository's store number, and ExtraNumber is the additional number that input second. condition is to find the record that you want to update.
Update tablename Set StoreNumber=StoreNumber+ExtraNumber Where condition.
here tablename is your table name. StoreNumber is the repository's store number, and ExtraNumber is the additional number that input second. condition is to find the record that you want to update.
Limu 2000-06-21
- 打赏
- 举报
Use this SQL Statement:
茂奇软件 2000-06-21
- 打赏
- 举报
select distinct ...
or
select ... group by
good lucky.
or
select ... group by
good lucky.
thinking_man 2000-06-21
- 打赏
- 举报
你可以先用一个变量将上次的数据保存下来，当UPDATE时，再进行相加，保存。
