[firebird-support] FOR UPDATE [OF ...]] WITH LOCK

Hi,   what is OF and three dots after? FOR UPDATE [OF ...]] WITH LOCK (README.explicit_locks)   it looks like we can write after OF something more - but what?   regards, Karol Bieniaszewski

RE: [firebird-support] FOR UPDATE [OF ...]] WITH LOCK

<> "The clause can take an optional OF to target updates at specific cursor columns" The Firebird Book Vol 2 p220 Regards Paul

Re: [firebird-support] Re: Uneven results from Round(x, 3) function

Dmitry has (of course) given you the correct answer. What you may overlook, is that DOUBLE PRECISION is a floating point number, and floating point numbers are often approximate and not exact. DOUBLE PRECISION is exact to 15 digits, after that random values may occur. NUMERIC, on the other hand is

Re: [firebird-support] FOR UPDATE [OF ...]] WITH LOCK

Hi, thanks you Paul regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Thursday, June 9, 2016 11:03 AM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] FOR UPDATE [OF ...]] WITH LOCK <> "The clause can take an optional OF to target upda

Re: [firebird-support] When do triggers take effect?

Tim Ward wrote: >> Using Database Workbench I added a trigger to a table, but it didn't >> seen to do anything (in particular didn't throw an exception which it >> should have done when I deliberately created an invalid record). >> After restarting DBWB the trigger behaved as expected. >> Do t