Questions tagged as 'firebird'

Tagged questions
2
answers

model and controller in codeigniter to do insert in firebird using generator

I'm new to codeigniter and I need to define my controller and model, so when calling the model inserir() , the controller takes the last ID of the generator of each table that wants to do the insert. Let me give you an example: control...
asked by 13.01.2016 / 14:24
1
answer

Using Firebird database from one PC to another

I backed up a Firebird database from a PC and what happens is that I put this database on another PC but then the application says that the database is unique to another user ie the program should do some folder check or user name that is in the...
asked by 11.06.2015 / 14:48
4
answers

Run query that concatenates parameters (@p) in Firebird

I need to execute a query where the value to be concatenated should be passed as a parameter to the query. SELECT t.id || @p || t.nome FROM Test t; But when you run this query it returns the following error: Dynamic SQL Error. I...
asked by 03.09.2014 / 13:34
2
answers

SQL Query with Duplicate Items

I have this situation and I do not know why it happens. When I pass this SQL command the displayed items come duplicated. What do I do to show an item of each without by the DISTICT SELECT T1....
asked by 10.07.2017 / 20:47
2
answers

Which database is ideal for my scenario?

I am developing a commercial automation system (C # and Windows Forms) that can be installed on one or more machines on the same local network. I've also done the mobile part of the system, where you can place requests through any device th...
asked by 31.05.2016 / 06:11
1
answer

mb_convert_encoding vs utf8_encode ()

I did an update of php on the server and I identified that they were not being encoded in the utf-8 pattern, the first thing I checked was the connection class I use, which in this case is adodb . In my connection I perform...
asked by 03.11.2015 / 19:38
2
answers

How to optimize Firebird 3?

Does anyone who works with Firebird 3 know exactly how to optimize the SGDB to be more efficient? So far I have done some tests with Firebird 2.5 and 3 to compare queries, and basically it continues the same thing. Update I realized that op...
asked by 22.06.2017 / 19:43
3
answers

Firebird suspend function

What is the role of suspend in a procedure in Firebird?     
asked by 18.07.2014 / 23:12
1
answer

Proposed Cartesian Product

I need to create a purposive Cartesian product, for a report in Fast reports or multiply my data by a certain number EX: select cli.cdclifor, CLI.nmCliFor from cadclifor cli where cli.cdclifor = '000001' result: 000001 Jõao das Cou...
asked by 12.09.2014 / 22:48
2
answers

Case no order by

I'm trying to make an order by the result of sql: sql.... order by cod_rua, case cod_lado when 'M' then cod_lado desc else cod_lado ASC end, cod_altura Only you are giving error in desc. Staff did not work: order by r.cod...
asked by 04.05.2017 / 19:18