[firebird-support] Help with error message (Firebird 3)

2020-01-23 Thread 'Paul Coshott' p...@coshott.com [firebird-support]
Hi All, I am getting an error during an sql insert, done with Firedac within a delphi vcl app. The error is: [FireDAC][Phys][FB]violation of PRIMARY or UNIQUE KEY constraint "INTEG_50" on table "ROSTER" Problematic key value is ("ROSTERID" = 19) The field ROSTERID is the primary

Re: [firebird-support] Isql exclusive mode?

2020-01-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.01.2020 11:59, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > So is it correct that I avoid embedded mode by specifying > "localhost/3050:AliasName" instead of just "AliasName"? Yes. -- WBR, SD.

Re: [firebird-support] Isql exclusive mode?

2020-01-23 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
Den 2020-01-23 kl. 11:32, skrev Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]: > 23.01.2020 08:32, Kjell Rilbe kjell.ri...@marknadsinformation.se > [firebird-support] wrote: >> Can anyone explain in which situations this happens, and in particular >> how I can make sure it does

Re: [firebird-support] Isql exclusive mode?

2020-01-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.01.2020 08:32, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Can anyone explain in which situations this happens, and in particular > how I can make sure it does NOT happen? If it is version 3 - do not use embedded mode. -- WBR, SD.