Hi, thanks for your response I put the table script in txt.
CREATE TABLE CABECERA_PROCESO
(
IDCABECERA Bigint NOT NULL,
COD_GESTION Varchar(15) NOT NULL,
IDPROCESO Smallint NOT NULL,
IDSUBPROCESO Smallint NOT NULL,
COD_ALBARAN Varchar(50),
IDESTADO Smallint DEFAULT 1 NOT NULL,
Additional information:
3 – About point 3, I have recreated the FK regarding field IDESTADO in the
table and now I am obtaining the record when fetching with IDESTADO = 3.
Nevertheless I am still not capable of solving point 1, I am not fetching that
record from ISQL nor Flamerobin, just fro
I have three tables Guidance, Assignment and Review. Assignment is a detail
table to Guidance and Review is a detail table to Assignment. When a new
record is entered into the Guidance table I want to an after insert trigger on
the Guidance table to insert default values into Assignment and R
Hi,
Easiest is as follows:
define your sequence trigger to be:
IF (coalesce(new.idcolumn, 0) = 0)
then new.idcolumn = gen_id(mysequence, 1);
Then, in your trigger:
declare myassid bigint;
begin
myassid = gen_id(mysequence, 1);
insert into assignment(assid, ... other columns ... )
values
Thanks Martijn. Your suggestion worked perfectly
Bernd,
>do you have an idea, when the packager will be supported El Capitan or is any
>other way manually to install firebird?
I am working on it.
The pkg installer is undergoing a complete re-write to comply with Flat Package
Format.
Regards
Paul
Hello everyone
There is the possibility of ordering the result of a SELECT in an order
specified by the user.For examplehaving a field NAMEin the clause ORDER BY
'PAUL, JOHN, PETER, MARIA'
Of course, that should be all the options set
Thank you.
Hola a todos
Existe la posibilidad de ordenar el r
Given that a query needed to return data for a page of a grid is of the form
SELECT FIRST 25 SKIP
.ID (and some other fields of human-readable data)
FROM < plus tables as needed for other fields in the
SELECT, WHERE and ORDER BY clauses>
WHERE
ORDER BY
how can I find out what is for a given
I am wondering if any of you have every noticed any significant performance
difference between using BIGINT versus INTEGER as an autoincremented
primary key in Firebird. My idea is to use BIGINT and have virtually
unlimited records ("set it and forget it" approach), but if I am going to
incur a rea
Hi,
ORDER BY CASE USER_NAME WHEN ‘PAUL’ THEN 1 WHEN ‘JOHN’ THEN 2 .. END
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Tuesday, October 06, 2015 5:20 PM
To: Firebird Support
Subject: [firebird-support] Order by
Hello everyone
There is the possibility of
I am wondering if any of you have every noticed any significant performance
difference between using BIGINT versus INTEGER as an autoincremented
primary key in Firebird. My idea is to use BIGINT and have virtually
unlimited records ("set it and forget it" approach), but if I am going to
incur a rea
Den 06.10.2015 17:38, skrev Tim Ward t...@telensa.com [firebird-support]:
> Given that a query needed to return data for a page of a grid is of the form
>
> SELECT FIRST 25 SKIP
> .ID (and some other fields of human-readable data)
> FROM < plus tables as needed for other fields in the
> SELECT, W
Excellent, very simple. Thank Karol
El Martes, 6 de octubre, 2015 16:32:08, "liviusliv...@poczta.onet.pl
[firebird-support]" escribió:
Hi, ORDER BY CASE USER_NAME WHEN ‘PAUL’ THEN 1 WHEN ‘JOHN’ THEN 2 .. END
regards,Karol Bieniaszewski From: mailto:firebird-support@yahoogroups
Hi Paul,
Thanks for your work. Looking forward to using it.
Kind Regards
Trevor Watters
Germán, as you can read Spanish, this article can be useful:
https://firebird21.wordpress.com/2014/11/20/mostrando-los-resultados-ordenados-por-cualquier-criterio/
Greetings.
Walter.
On Tue, Oct 6, 2015 at 6:17 PM, Germán Balbi bal...@yahoo.com
[firebird-support] wrote:
>
>
> Excellent, very
Kevin Meyers kevinjmey...@gmail.com [firebird-support] schrieb am 06.10.2015
22:36:
> I am wondering if any of you have every noticed any significant performance
> difference between using BIGINT versus INTEGER as an autoincremented
> primary key in Firebird. My idea is to use BIGINT and have vir
16 matches
Mail list logo