Questions tagged as 'firebird'

Tagged questions
1
answer

How to create this procedure

I have these two tables in the bank cadcha (Cadastro de chamadas) cadram(Cadastroderamal) Allconnectionsmadetoacertaincompanywillbesavedinthistablecadcha.Thedestinationextensionfieldistheextensionthatansweredormadethisconnection.Ialsohavea...
asked by 17.12.2015 / 16:11
2
answers

Could not find driver (PDOException "could not find driver")

I'm trying to make a connection to my FIREBIRD database, but when I organize it correctly, I put the IP where it's located, etc. The message appears:    IT WAS NOT POSSIBLE TO LOCATE THE DRIVER IN c / wamp / www //// What should I do pers...
asked by 01.07.2015 / 17:03
2
answers

How to use firebird 2.1 ABS in firebird 2.0?

I have a client that already has a system that runs in firebird 2.0 and my system runs in the newer version of firebird, so I had to regress the database and have some functions that 2.0 does not have yet ... Like me could you do ABS (catch abso...
asked by 30.04.2018 / 16:43
1
answer

"gen_id ()" or "select max ()" for Auto Increment in a PK field?

I currently use a Trigger with this SQL code to get an Auto Increment to be assigned in the primary key field ( PK ) of tables: create or alter trigger TRI_CLIENTES_BI for CLIENTES active before insert position 0 as begin if (new.ID is nul...
asked by 07.11.2017 / 16:53
1
answer

SQL - Delete records that have field with the same value as another, only when there is more than one record

I have a barcode table of products, I want to delete only the barcodes that are equal to the product code and have another code besides this. Table: CodProduto CodBarra 01 01 < não deletar 02 02 <...
asked by 16.08.2017 / 18:13
1
answer

Firebird + EntityFramework with Visual Studio 2015

Hello, I need to create a firebird connection with visual studio, but I'm having problems with the integration, I searched for videos on the internet, and only have reference of 2012, I did not find anything more current. I want to build my so...
asked by 10.02.2017 / 19:13
1
answer

Unsupported on-disk structure

I was developing in Delphi using Firebird 2.5. And it started giving an error when trying to connect to the local database. When trying to connect it gives the following message: Error: unsupported on-disk structure for file C:/....meucaminho....
asked by 13.06.2016 / 13:46
1
answer

Keep database connection open in PHP

When we use a PHP application with Firebird database, we use the ibase_connect() methods to open the connection to the database and ibase_close() to close this connection. If the connection is opened and not closed using the last c...
asked by 11.12.2015 / 01:57
2
answers

How can I use the UPDATE command between two tables?

I'm trying to update the GRUPO field from the ESTOQUE table to the value 1 (one) when the NCM field of the EST_ADICIONAIS table is equal to 21011000 . Therefore, both tables have the CODIGO field with equ...
asked by 26.03.2015 / 15:49
1
answer

I can not load firebird data in Delphi XE2 using TZQuery

I have a TZQuery created, and I try to load the fields SEQ_CTE and SERIE_CTE according to the code below: ZQuery1.sql.text := 'select * from C000004 where filial = '' + frmprincipal.spanel1.caption + '''; ZQuery1.open; ZQuery1.exec...
asked by 17.08.2014 / 22:30