Questions tagged as 'firebird'

1
answer

Firebird - Select to join two or more rows

I have a table with the following structure: Cliente_id | credito | debito | pedido 1 100 1 1 150 1 1 30 1 2...
asked by 09.09.2016 / 21:20
3
answers

Sorting using DbGrid with ClientDataSet

I'm using a DbGrid together with a DataSource. And I want to do the ordering as the customer clicks on the title. I made the following settings: In my Dbgrid in the DataSource property linkei my DS. In my Ds in the DataSet property I linkei my C...
asked by 13.06.2016 / 21:07
1
answer

Firebird Embarcado

I made an application that I want to use Firebird on board, I follow all the steps of the tips on the net, but on my machine it works but when I send to another computer it can not find the DLL. I followed the steps in the tutorial , but the...
asked by 10.11.2014 / 18:49
0
answers

Reading fields of type BLOB with node-firebird

I would like help finding a way to read a field of type BLOB as a string using the "node-firebird" module of npm, below the code and problems that I can not handle alone. db.query(query, parameters,function (error, result) { if (error)...
asked by 12.12.2018 / 19:26
0
answers

Firbird configuration for use in a windows server 2012

I'm trying to set up Firebird on a server Windows server 2012 and I'm not getting good results ... The server has the following characteristics Processor - IntelXeon E3 1220 v2 3.10 GHz 8GB Ram Windows server 2012 This Serve...
asked by 13.12.2018 / 13:40
0
answers

Integration between two databases

I have an idea of integrating two databases, at one point I have the PostGresSql with system A and on the other side a Firebird in system B.    For example: I wrote a client on system A and I need to export to   system B. In addition...
asked by 08.12.2018 / 00:29
1
answer

Error connecting to Firebird database with NodeJS

I'm trying to connect to a Firebird test bench with NodeJS, and I'm using the package node-firebird link here , and I'm having the following error when trying to connect.    Error node index.js Error: Connection is closed. at e...
asked by 05.12.2018 / 00:01
0
answers

Error procedure holiday

Good afternoon guys, I'm trying to create a procedure and I can not solve my error even after several searches on the net, if you can help me, the error that appears is this: can not format message 13: 393 - message file C: \ WINDOWS \ firebi...
asked by 01.12.2018 / 18:28
1
answer

Search item result on the same line separated by commas

I have a select that returns the risks (job security) in several lines, I would like the item "T4.RIS_RISCO" to appear in a single line separated by a comma, can anyone help me ??? I have basic knowledge ... SELECT T1.ASO_ID, T1.RIS_ID,...
asked by 30.10.2018 / 12:22
0
answers

How do I update a firebird date, time, minute, and seconds field by removing part of milliseconds?

There is a simple update statement that I can perform to update a date, time, minute, and seconds field in a firebird to remove part of milliseconds. then the current value is: 10/03/2017 17: 30: 51.3560 I want to update it to be: 10/...
asked by 03.10.2018 / 22:32