Best answeres tagged with firebird

1

answer

Column to write date and time of change SQL Server

I am migrating a database from Firebird to Sql Server and today, in Firebird I have some triggers in Before Insert/Update that write TimeStamp of insertion / change and user logged in. Is there any way I can...

asked by 11.03.2016 / 18:13

2

answers

Query does not sort records by Asc / Desc

I have a table called cadcha (call register) in the database where all the calls made by the employees of a certain company are stored. cadcha -------------------------------------------------- nreg |telefone |telpretot |ramaldest...

asked by 16.12.2015 / 13:45

2

answers

Error: "connection rejected by remote interface" using Firebird 3 in .Net

I have an application in asp.net, which currently uses firebird 2.5.1 and works normally. I am testing version 3.0 Release Candidate for migrate the version soon, but does not open the connection, the following occurs: error: "connection r...

asked by 16.12.2015 / 13:14

1

answer

"arithmetic exception, numeric overflow, or string truncation string right truncation" in search using LINQ

I have a table in a Firebird database CREATE TABLE CIDADE ( CID_CD SMALLINT NOT NULL, CID_DS CHAR(20) NOT NULL, CID_UF CHAR(2) NOT NULL, CID_DISTANCIA_SEDE SMALLINT NOT NULL, CID_CD_ALTERNATIVO INTEGER...

asked by 08.01.2016 / 17:13

1

answer

Mounting a SQL for School Bulletin?

asked by 25.10.2015 / 03:29

0

answers

Writing text formatted in the firebird database

I know you have a similar question with this plus is for tag C# Have you saved the formatted text to a TRichEdit in Firebird ? What would be the data type of the field that enables this recording?

asked by 12.05.2018 / 16:48

0

answers

Delphi sql using coalesce

In delphi I have TIBQuery: select * from TB_PRECO where coalesce(DT_CAMPANHA,'') = coalesce(:DT_CAMPANHA,coalesce(DT_CAMPANHA,'')) and coalesce(DT_VECTOPRECO,'') >= coalesce(:DT_ATUAL, coalesce(DT_VECTOPRECO,'')) and DESC_GRUPO = coalesce(:...

asked by 23.03.2018 / 20:53

1

answer

Search ip via sql

Does anyone know if there is a way I can search via sql (firebird) all the ips that are using a Table or Views? I'm trying to update a view, however I'm trying the following error: This operation is not defined for system tables. unsuccess...

asked by 04.01.2018 / 11:26

0

answers

Migrating from Firebird to MySQL

I am migrating a project in Firebird to MySQL, I have a difficulty in converting a procedure, I would like any tip in how to proceed, below the procedure in FIREBIRD. CREATE PROCEDURE EXECUTA_INATIVA_TABELAS ( OPERADOR VARCHAR(20), ALT...

asked by 09.01.2018 / 14:16

2

answers

Take tab (tab) of varchar

Good afternoon everyone! I'm trying anyway, but I can not seem to get a tab at the end of a varchar in firebird. Does anyone know how to do it? Thanks in advance. Editing to stay more specific: Ex: select guia, convenio, nome, tri...

asked by 09.02.2017 / 19:35

Questions tagged as 'firebird'