Oh. I just set it like that 14 years ago.
Thanks!
On Fri, Dec 15, 2017 at 11:25 AM, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] <firebird-support@yahoogroups.com> wrote:
> 15.12.2017 12:21, OB1 oldbasf...@googlemail.com [firebird-support] wrote:
> > Rec
wrote:
> 15.12.2017 12:04, OB1 oldbasf...@googlemail.com [firebird-support] wrote:
> > Yes. A pre-insert on both that checks the data and assigns a PK from a
> generator if one's
> > not assigned. Also checks valid data has been assigned and sets
> NEW.blah. No interaction
>
-support] <firebird-support@yahoogroups.com> wrote:
>
>
> Are there any INSERT triggers on either of the tables?
>
> 2017-12-15 11:44 GMT+01:00 OB1 oldbasf...@googlemail.com
> [firebird-support] <firebird-support@yahoogroups.com>:
>
>>
>>
>> Thanks
Hello
I'm using FBv1.56 with IBO.
I have a transaction (committed, lockwait = false) that simply inserts a
row into two tables. When inserting a row into the second table (and prior
to committing) I will occasionally receive:
ISC ERROR CODE:335544345
ISC ERROR MESSAGE:
lock conflict on no wait
We're making the jump from v1.56 to v3.0.2 (gulp!) and to make the
transition easier for our clients we wondered if v3 client libs
(fbclient.dll) can access 1.56 servers. We've tested this and it appears
to work, but wanted to confirm if it was officially supported.
Many thanks.
Hello Svein
Thanks for your reply. That made a big difference, down from 10 minutes
to 0.5 seconds :-)
c.Contact_ID is the PK for the contacts table, so I assume that's
automatically indexed. c.Company_ID also has an index.
Many thanks
David
On Thu, Jul 2, 2015 at 9:57 PM, Svein Erling