Questions tagged as 'firebird'

Tagged questions
2
answers

Trigger in firebird

I have this trigger, but I want to make it count before adding to see if the data already exists in the table so I do not add it twice. AS begin if (new.cantidad <= new.catidad_minima ) then insert into comprar (nombre_producto ,cantida...
asked by 19.07.2016 / 15:03
1
answer

Firebird and codeignter

Someone knows exactly what this error means in firebird    This column can not be updated because it is derived from an SQL   function or expression.Attempted update of read-only column. In codeigniter:    A PHP Error was encountered...
asked by 19.05.2016 / 21:00
2
answers

Failed to query in firebird with fdb in python 3

I try to make a query in a database using Firebird, this is my code: import fdb import os ruta = 'localhost:C:/Users/Beto/Documents/Proyectos python/Ruby/sama.fdb' try: con = fdb.connect( dsn = ruta, user = 'sysdba', password...
asked by 09.05.2016 / 05:36
1
answer

Connection with a Firebird database

Good morning, my doubt arises because I can not find a gem or how to use a database of firebird 2.5 in ruby 2.3.0 and rails 5.0.0.1 I want to create an alternative connection since by default it used a mysql database, but I need to insert, up...
asked by 01.09.2017 / 20:46
2
answers

TimeStamp field or Date and Time

In a table where there is a TimeStamp type field that is used, for example, among other things, to know the sum of all the records of a particular date, that is, by doing: select sum(campo_valor) from tabla where cast(campo_fecha as date)='201...
asked by 16.06.2016 / 07:31
1
answer

How to update records in null to an autoincrementable id to existing table with data

I have a table with data in Firebird, I need to create a field to have a unique id for each record, and add the field that will be called ID, now how to update the existing records so that they have a unique and autoincrementable ID for new reco...
asked by 21.11.2018 / 19:55
1
answer

Native development environment for Firebird databases

I am looking for a native development environment for Firebird databases, ie SQL Server Management for SQL Server or MySQL Workbench for MySQL. I hope you can help me. Greetings     
asked by 03.01.2018 / 18:23
1
answer

Firebird materialized views

Good afternoon colleagues, I'm trying to improve the performance of a database in Firebird 1.5; I've noticed that the consultations I do on some views take too long, and I read there is a way to materialize the view to improve performance. I'...
asked by 20.10.2017 / 22:15
1
answer

SQL Available Matters for a Career

Good evening friends, I have days killing me with an SQL that I do not know how to do, I tell you I am developing a system for the management of universities, and I am trapping in the list of available subjects. I have these tables: CREATE TAB...
asked by 25.09.2017 / 01:38
0
answers

Firebird connection problems with .ib database (Interbase)

I have a problem and I can not connect to my database .IB (Interbase) with firebird. The fact is that I downloaded Firebird 3.0 and I do not know how to connect to the interbase database I have. Do I need any more software? Normally in...
asked by 04.09.2017 / 23:45