if i open table via recodset i can do something like this..
then what i ask is if i want to use UPDATE SQL..is there possible to do something like that?VB Code:
- rs("qty") = rs("qty") - 1
- if rs("qty") <= 0 then rs.delete
thx for the input..