Posts by Edison de Brito • 71 points
10 posts
-
1
votes1
answer904
viewsA: Format Firebird SQL data dd/mm/yyyy
The databases, not exclusive to Firebird, store the dates by the numeric representation, the date type in Firebird stores in a 32bit integer, so the desired behavior depends on where you will…
-
0
votes2
answers256
viewsA: Firebird sql error and doubts
It is not clear in the description of the problem the objective of defining as key the attribute news.Slug and as this following a documentation of a framework I believe I have no knowledge of the…
-
0
votes1
answer417
viewsA: Transfer fields from one table to another
Ibexpert has the database comparison feature (Menu Tools, Database Comparer), which compares the two databases and generates a script with the necessary changes. By running this script in the target…
-
0
votes3
answers406
viewsA: Insert decimal variable in Firebird
The problem is not fully clarified in the question because there is no structure of the tables involved. More information about Firebird numerical data types can be accessed at: Fixed-Point Data…
-
1
votes1
answer601
viewsA: How to synchronize auto increment keys between different databases in Firedac?
Let’s go in pieces: First: Firedac is data access so auto-increment is something from the database and not firedac. The auto increment option is available in Firebird 3 without using the combination…
-
0
votes3
answers406
viewsA: Insert decimal variable in Firebird
Not working with C# but is using product.Valuario to convert the value and entity.Valuario to concatenate the SQL String. If this is correct, ok, but check the contents of the SQL variable, which…
-
0
votes2
answers498
viewsA: Check values with 0 included in Count() even if they do not have values
utilise HAVING before the order by add HAVING COUNT(*) = 0.
-
1
votes2
answers565
viewsA: Firebird Select Query using same field twice
You can use a case: select count(case when(paciente_id='0') then paciente_id else null end) as id0 , count(case when(paciente_id<>'0') then paciente_id else null end) as idok from agenda`…
-
0
votes2
answers584
viewsA: Make a General Sum with all fields
Do so: select sum(tb_movimento.QUANT * (case when tb_produto.tipo='ALIMENTO' then 1 else 2 end)) from tb_movimento inner join tb_produto on tb_produto.cod_prod = tb_movimento.cod_prod Improvement:…
-
1
votes2
answers7173
viewsA: Firebird SQL auto-increment
In Firebird 3, you now have auto-increment field support: id integer generated by default as identity primary key