Questions tagged as 'firebird'

Tagged questions
1
answer

Equivalence of the Firebird GEN_ID () function in ORACLE

Speak, I'm learning BD Oracle, before I used firebird. But I'm having a problem that I can not solve. I can not add a new country through the system (java), if I enter it through SQLDeveloper, it appears in the query. The error that appears when...
asked by 07.03.2017 / 17:55
2
answers

Exporting FireBird data

I have a client registration program connected to Firebird, however I will no longer use this program and need the data. Would you like me to get the file database.fbd, which I'm afraid you are all registered and generate some excel or something...
asked by 20.12.2015 / 22:47
1
answer

Change ZIP Code column inserting hyphen character in Firebird

I have a table of cities where I have zip codes. The data looks like this: 89620000 I would like to leave them like this: 89620-000 How can I do this in Firebird?     
asked by 20.12.2014 / 02:08
1
answer

Problem in the size of the FK name

I have a WebApi to work with a database of Firebird 2.5 , I used at the time the EF, but today it is presenting me with the following error    "The name 'FK_ARRUMACAO_CHECKLIST_ARRUMACAO_ARRUMACAO_ID' is longer   than Firebird's...
asked by 21.09.2018 / 20:33
1
answer

Group sum by month and year

I have a simple table in a FIREBIRD database: idCliente: integer dataPagamento: date valor: numeric How to make a select that adds up all the amounts to be paid by grouping by month and year? type like this: select MES_ANO, sum...
asked by 11.06.2018 / 21:48
2
answers

Display data in PHP table

I am doing a sales report and need to organize the data coming from a bank in firebird to make a report in PHP , but I am not able to know how much data is coming from the bank. Because the ibase_num_fields function does not return...
asked by 13.10.2017 / 20:25
1
answer

Return code of data entered immediately after INSERT

I know with java to do, but I do not find anything to do this in delphi (if possible), whenever I register a new item I search for the code by SELECT MAX ('FIELD'), but I would like to know if it is possible to return the code soon after the INS...
asked by 05.10.2017 / 19:54
1
answer

How many percent N item represents in the grand total - Query

Good morning, I'm creating a report on the ABC curve, but I'm a beginner and I still have some difficulties. I have a table called: ITEMS. With fields: COD_ITEM, Sales Quantity, Unit Value, Subtotal, Description With an SQL query I was abl...
asked by 12.05.2017 / 15:32
3
answers

Trigger to update date modified date in firebird

I have a client table with the Registry Data Date and Registry Modification Date fields would anyone know how to create a trigger that updates the Modified Date column of this customer table every time a row is changed, so far I've...
asked by 02.09.2016 / 14:22
3
answers

SQL - Doubt in a query

Thanks to Motta's help I managed to get into a satisfactory query but I ran into another query because I need to list only the smallest record by cod , and count the amount of the menorregistro column by name. > Could someone help...
asked by 28.07.2016 / 17:54