[firebird-support] Invalid token.invalid request BLR at offset 1745. Input parameter mismatch for procedure

2016-12-06 Thread 'Israel Pinheiro' israel.ip...@gmail.com [firebird-support]
Error in procedure. Please! ALTER PROCEDURE EQPRODUTOSP01 (ICODEMP INTEGER, SCODFILIAL SMALLINT, ICODPROD INTEGER, ICODEMPAX INTEGER, SCODFILIALAX SMALLINT, ICODALMOX INTEGER, DTPESQ DATE) RETURNS (NSALDO NUMERIC(15, 5), NSALDOAX NUMERIC(15, 5), NCUSTOMPM NUMERIC(15, 5), NCUSTOPEPS

RE: [firebird-support] SS FB3.01 - Is it possible to set CPU utilization to max?

2016-12-06 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
Anto, > During project development/testing or database maintenance, such as > backup/restore, mostly, there is only 1 connection to FB Server. > > I have 6 core processors and during those process, cpu's utilization is > about  16%. I knew, this is because there is only 1 connection to FB

Re: [firebird-support] SS FB3.01 - Is it possible to set CPU utilization to max?

2016-12-06 Thread fabia...@itbizolutions.com.au [firebird-support]
Anto Each "request" to the database is managed by one CPU, and 6 CPU will be used in full when 6 concurrent requests are passed to Firebird, however to get Firebird to process each request with all available CPUs is not possible at the moment, it would require a re-write of Firebird. Regards

Re: [firebird-support] JOIN ON SELECT PROCEDURE

2016-12-06 Thread hugo.lar...@yahoo.com [firebird-support]
Thanks.

Re: [firebird-support] JOIN ON SELECT PROCEDURE

2016-12-06 Thread hugo.lar...@yahoo.com [firebird-support]
Thanks Dimitry. BR, Hugo

Re: [firebird-support] JOIN ON SELECT PROCEDURE

2016-12-06 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
06.12.2016 8:18, hugo.lar...@yahoo.com [firebird-support] wrote: > *I tried the following but it does not work. * Your join must be right, not left in this case. -- WBR, SD.

[firebird-support] Cannot access database on second server.

2016-12-06 Thread corni...@gmail.com [firebird-support]
Hi My software using FB 2.54 (SuperServer) and Firedac (Delphi 10.1) connected fine on a workstation to the "SERVER". All the required connection files are in the software folder and I did not do the FB Client installation on the workstation. Another company then did a custom Firebird

[firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-06 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
06.12.2016 11:50, Mark Rotteveel wrote: > I noticed something interesting, when restoring a Firebird 2.5 database > to Firebird 3.0, only user generators (RDB$SYSTEM_FLAG = 0) get a value > of 1 in RDB$GENERATOR_INCREMENT, system generators get 0. Is that > intentional? System generators are not

Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-06 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 6-12-2016 09:23, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: > Check RDB$GENERATOR_INCREMENT inside RDB$GENERATORS. NEXT VALUE FOR uses > the increment stored inside the system table. I noticed something interesting, when restoring a Firebird 2.5 database to

[firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-06 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
06.12.2016 11:05, Roland Turcan wrote: > > I have installed new clean database to new customer having FB3.0.1 > 32bit running on Windows7Pro 32bit. He was complaining that he is not > able to add new record into some parts of our software. I have > connected to his computer and

[firebird-support] NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-06 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
Hello firebird-support@yahoogroups.com! I have installed new clean database to new customer having FB3.0.1 32bit running on Windows7Pro 32bit. He was complaining that he is not able to add new record into some parts of our software. I have connected to his computer and made