I would like to know if there's any way I can do a query where I can bring fields that are not in my group by .
I have the following code:
select sum(TAB_FATURAMENTO.vl_item),CLIENTE.insc_cnpj
from TAB_FATURAMENTO
inner join (IMP_PROC...
Hello, I am doing an SQL query on my Firebird server.
I made the query using the following syntax:
select ds_produto_servico, count(ds_produto_servico) from tb_produto_servico
group by ds_produto_servico
having
count(ds_produto_servico) > 1...
I downloaded Linq2db.Firebird using the following code:
Install-Package linq2db.Firebird
The installation was successful, but I can not find in Visual Studio anything related to it, I do not know how to use it and I did not find a go...
Error in insert in firebird database, field DataCadastro type timestamp does not accept string .
INSERT INTO VENDA(CODIGO, NRO_VENDA, DATA_VENDA, VALOR_TOTAL_PRODUTOS, VALOR_ACRESCIMO,
VALOR_DESCONTO, VALOR_TOTAL_VEN...
My Sales table has a Code field with auto-increment and I need to retrieve this code to insert into an associative table.
string sql = $"INSERT INTO VENDA(NRO_VENDA,DATA_VENDA,VALOR_TOTAL_PRODUTOS,VALOR_ACRESCIMO,VALOR_DESCONTO,VALOR_TOTAL...
I'm doing an Insert in the Firebird database in a UnitUnit (decimal) field, but the decimal places in the table do not appear.
C # code:
public decimal ValorUnitario { get; set; }
produto.ValorUnitario = Convert.ToDecimal(5.50);
string sql...
I'm trying to pass a script to create and insert data from a Firebird database to PostgreSQL, however in some tables syntax error is occurring, I'm using the SQL Manager Interbase & Firebird to generate the * .sql files from my Firebird data...
My script PHP is not receiving the exceptions message that is generated by Firebird . I have a class that connects to DB, runs sql, and disconnects.
By debugging the script, I saw that exception is being generated b...