May 29, 2024, 09:07:35 AM

News:

Own IWBasic 2.x ? -----> Get your free upgrade to 3.x now.........


Access errors

Started by billhsln, May 29, 2018, 11:01:44 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

billhsln

I have a program I have been working on and I noticed that when I try to UPDATE a record that does not exist, ACCESS does not come back with an error.  I need it to error if there is no match.  I ended up having to change the code to do an INSERT, which worked.  Just don't understand why the UPDATE did not give me an error when the record did not exist.

Thanks,
Bill
When all else fails, get a bigger hammer.