Questions tagged as 'firebird'

Tagged questions
2
answers

Receiving error: "Your SYSDBA login is the same as one of the SQL role name" when trying to access base with IBExpert

I need to access data from a firebird database (.FDB), but when trying to access this database using IBExpert I get the following error:    "your SYSDBA login is the same as one of the SQL role name". In my research, I discovered that thi...
asked by 08.12.2014 / 14:45
2
answers

Select with expression "other than" with two conditions

I would like to know if there is any way to make a select using a where for a field with a parameter other than < > , with two or more items. To facilitate following example: select * from TAB_DESPESAS where cd_ite...
asked by 31.07.2017 / 22:58
2
answers

Firebird SQL auto-increment

I'm doing a SQL / Modeling course in mysql the creation of a composite table would look like this: USE banco; CREATE TABLE clientes( cli_id integer not null auto_increment, cli_nome varchar(20) not null, cli_email varchar(30) not null...
asked by 21.11.2014 / 16:54
2
answers

Open xls (password protected) file in Delphi and save data to Firebird table

I have a password-protected office file ( .xls ) that has multiple rows. I want to do a search for the contents of the column 1 and knowing the line that is the result I want to save this single row in a Firebird database table. Example:...
asked by 10.02.2015 / 03:42
1
answer

Sql group records

I have the following query: select T1.dt_producao, T1.cod_turno, T1.cod_periodo, CASE WHEN T2.TP_PALLET = 'DZ' THEN sum(T1.QT_PROD* T2.QT_EMBALAGEM*12) ELSE sum(T1.QT_PROD* T2.QT_EMBALAGEM) END AS "APON.TOTAL", (...
asked by 05.10.2016 / 16:20
3
answers

firebird, native function to format date

Is there a native firebird function that formats the date (date)? As in Mysql we have the DATE_FORMAT () function would have something similar in firebird?     
asked by 06.07.2015 / 22:59
3
answers

Firebird, insert with where not exists

I'm trying to insert a record into the table, but this record will only be inserted if it does not already exist there, so I'm trying to do it like this: INSERT INTO R01 (NUMERO,EXPORTADOR, IMPORTADOR, DATAANTECIPADO, STATUS) VALUES (64, 'CCB...
asked by 20.07.2015 / 16:07
1
answer

Error "The resultSet is closed" with PreparedStatement

I'm getting this when I'm traversing a ResultSet and get other ResultSet s: public class BpaDetDao extends DaoAbstract<BpaDetBean> { public static final String // TODO Colocar campos no select SQL_SELECT =...
asked by 29.06.2015 / 22:20
1
answer

How to set charset UTF8?

I have a database that was created using Firebird 1.0, at that time there was no available UTF8 charset, only from version 2.0 it was possible, so we left charset none. Questions: 1 ° How can I define UTF8 charset? remembering that the cha...
asked by 29.01.2016 / 16:05
1
answer

Calculating dates in firebird

I am creating a report to demonstrate the period of dismissal of employees, so I need to calculate the days, months and years that it has been removed, and I am having a problem, in Firebird I use something like datediff(day,dtini,dtfim) ,...
asked by 03.12.2014 / 12:36