Questions tagged as 'firebird'

Tagged questions
1
answer

Firebird - Parameterized View

Hello. I need to create a View where I will use a parameter whose value will be provided at runtime (Delphi). Could someone give me an example? Thankful.     
asked by 02.06.2016 / 22:28
0
answers

How to recompile all Views, procedures and triggers in Firebird?

I need to recompile all Views, procedures and triggers in Firebird, not by IBExpert, but by Delphi XE2, I will pass a SQL, I would like to know how to perform such a procedure.     
asked by 17.05.2016 / 19:16
0
answers

Firebird ADO.NET

I updated the "Firebird ADO.NET Data provider" to version 4.10.0 and I am sometimes getting the following exception in my application. Exception information: Exception type: NullReferenceException Exception message: Object reference...
asked by 26.04.2016 / 17:17
0
answers

Firebird database with problems

I have a new Firebird Database, deployed less than 60 days, until then little used, in one day its size was 40 Megas, in less than 6 hours users complain about slow system, when verifying the Database is at 126 Gigas. How is this possible, what...
asked by 05.04.2016 / 15:45
1
answer

Creation of Trigger for INSERT in another table in IBexpert

Good morning, I had the need to create a stock control, but I had never used a trigger. I have 3 tables COMPRA ABASTECIMENTO and MOVIMENTO_ESTOQUE Table MOVIMENTO_ESTOQUE : I would like that when I make...
asked by 15.02.2016 / 12:07
1
answer

firebird execute statement within an exists

I would like to know how to step in the table name as a parameter create or alter procedure TESTE ( TABLENAME varchar(30), STATUS varchar(1)) returns ( INCREMENT integer) as declare variable RESULT varchar(254); begin if (STATUS...
asked by 02.01.2016 / 22:16
1
answer

Locale database + node.js

I'm working on a project using node.js. I need to use a local database, but I wanted to reconcile performance with security, and if possible, portability as well. I only know MS Access (.accdb) and Sqlite3. [MS ACCESS] Prós: Senha...
asked by 13.11.2015 / 20:08
0
answers

Configuring Firebird with PHP?

I am using XAMPP / LAMPP with CentOS and am trying to configure PHP to connect to a Firebird database. In php.ini I already uncompressed the extension="interbase.so" line and copied the interbase.so to the /opt/lampp/lib/...
asked by 22.10.2015 / 05:59
0
answers

Registry is not updated in the database

I have an application that takes the content of a particular site and compares if it is different from the current one comparing with the registry in the database and sends an email that had a change, besides updating in the database with the ne...
asked by 16.10.2015 / 14:35
0
answers

Firebird bug with Entity Framework and C #

I'm trying to use Firebird with Entity Framework in C #, but when I create relationships and try to give Update-Database in Migration it gives this error:    Type is not resolved for member 'FirebirdSql.Data.FirebirdClient.FbException, Firebi...
asked by 01.03.2016 / 20:42