[firebird-support] Partial update

2017-02-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
Hello, All. If I use prepared statement like this "update table set field1=?, field2=? where field3=?" for performance reasons, is there a way to update only some fields and leave other untouched without overhead of building separate queries on the fly or selecting old values with

RE: [firebird-support] Weird behaviour

2017-02-13 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
> A thread is trying to perform a SQL select, a client wants to display detailed > information for a certain row. > Basicly Select * from TABLE where PKEY = PKEY > The thread acquires lock in our server, then works it's way through GDS32.dll > (fbclient.dll) and then times out on the call to

[firebird-support] Deadlock - expected behaviour

2017-02-13 Thread john_karlsson_...@yahoo.com [firebird-support]
Hi All! I have currently been looking into an issue where one of our clients seem to be experiencing a deadlock. However I am not a Firebird expert so I think I might need some help, hopefully someone could point me in the right direction. In short: I have narrowed it down to being due to one

[firebird-support] Weird behaviour

2017-02-13 Thread john_karlsson_...@yahoo.com [firebird-support]
Hi All, I have encountered something that I would describe as weird behaviour, although I must admit that I'm not an expert on Firebird and cannot say whether this should be expected or not. So... first some basic info: We have a system which relies on Firebird for persistent storage. The