[firebird-support] How to return a IDENTITY field before insert it?

2018-02-14 Thread Elton Fadel galdari...@yahoo.com.br [firebird-support]
I don't know why identity is better then the old method, but if we can't have access to the next number, this can be useless in some cases. How to get it like we did on FB 2.5 with a procedure to get the next ID of a generator?

Re: [firebird-support] How to return a IDENTITY field before insert it?

2018-02-14 Thread Elton Fadel galdari...@yahoo.com.br [firebird-support]
Thanks  (: Em Quarta-feira, 14 de Fevereiro de 2018 17:20, "Mark Rotteveel m...@lawinegevaar.nl [firebird-support]" escreveu:   On 2018-02-14 18:59, Omacht András aoma...@mve.hu [firebird-support] wrote: > Hi! > > Select gen_id(generator_name, 1)) as new_id from rdb$database You

[firebird-support] FB3 Embedded Firedac Error

2019-09-01 Thread Elton Fadel galdari...@yahoo.com.br [firebird-support]
Error: Failed to connect to DBMS ! [FireDAC][Phys][FB]Unable to complete network request to host "xnet://Global\FIREBIRD". Yes, I know I need only theses files for embedded: intl lib plugins > engine12.dll udf databases.conf fbclient.dll firebird.conf firebird.msg gbak.exe gfix.exe gstat.exe ib_ut

Re: [firebird-support] FB3 Embedded Firedac Error

2019-09-02 Thread Elton Fadel galdari...@yahoo.com.br [firebird-support]
Thank you all for the replies. All your questions are above together: 1. Is it Windows application? Yes. 2. Is it 32 bit application or 64 bit? 32 . 3. Which version of Delphi? Last one, 10.3.2 Rio. 4. How your Firedac connection params looks like? Database=D:\Desktop\Server\DB.FDB CharacterSe

Re: [firebird-support] FB3 Embedded Firedac Error

2019-09-02 Thread Elton Fadel galdari...@yahoo.com.br [firebird-support]
ar.nl [firebird-support] escreveu:   On 3-9-2019 05:38, Elton Fadel galdari...@yahoo.com.br [firebird-support] wrote: > /5. This error occurs when you are using a 'fbclient.dll' that doesn't have > access to 'plugins/engine12.dll'./ > /5b. This error ca

Re: [firebird-support] FB3 Embedded Firedac Error

2019-09-03 Thread Elton Fadel galdari...@yahoo.com.br [firebird-support]
2019 at 1:13 PM Elton Fadel galdari...@yahoo.com.br [firebird-support] wrote:   Thanks, Mark! It worked! I also notice something very interesting during my tests: 1. No matter if you use Firebird if a Service or Application, even without installing the guardian:Stop the Service or do