openbsd-inetd: To accept remote connections. At least in Ubuntu.
Greeting.
Christian
Database Write Mode workstation and server?
http://www.firebirdsql.org/manual/gfix-sync.html
Regards.
Christian Mereles.
[Non-text portions of this message have been removed]
Ok, I understand. While the second table is not as complex but if you want
to take the index optimally try something like:
select first 1 n_orden from ordenes
where year_orden = new.year_orden
order by* year_orden desc, n_orden desc*
into new.n_orden;
Regards.
Christian
[Non-text portions of
Check the query, just read ONE REGISTER to return the MAX each year !!!.
select first 1 n_orden + 1 from ordenes
where year_orden = new.year_orden
order by year_orden desc, n_orden desc
into new.n_orden;
/*---*/
The query that you use does
Ok, some querys:
1 - No index:
select coalesce(max(o.N_ORDEN), 0) + 1 from ORDENES O
where O.EJER=2012 --into new.n_orden
https://dl.dropboxusercontent.com/u/15932768/sin_indice.jpg
2 - With index, uses multiple records:
create descending index ordenes_idx1 on ordenes (ejer,n_orden);
select
Hi,
This has to work:
gbak -c -v -t -rep fitxer.fbk fitxer.ib -user SYSDBA -password
masterkey *-FIX_FSS_D
ISO8859_1 -FIX_FSS_M ISO8859_1 *
Regards.
--
Christian.
[Non-text portions of this message have been removed]
Hi Dmitry,
You're right, in my restore script I have something like:
#!/bin/bash
FBK=$1
FDB=$2
gbak *-r -k -v *$FBK $FDB -FIX_FSS_D ISO8859_1 -FIX_FSS_M ISO8859_1
chown firebird.firebird $FDB
I was just emphasizing the fix options: -FIX_FSS_D ISO8859_1 -FIX_FSS_M
ISO8859_1
Thanks.
--
Hi,
Loop dates within a range:
create or alter procedure SP_DATES (
INICIO date,
FINAL date)
returns (
FECHA date)
as
begin
/* Procedure Text */
Fecha = inicio;
while (Fecha final) do
begin
Fecha = Fecha + 1;
suspend;
end
end
Regards.
-Christian-
[Non-text
Hi,
View the following:
http://paulbeachsblog.blogspot.com.ar/2011/07/firebird-v21-error-value-exceeds-range.html
Regards.
-Christian-
[Non-text portions of this message have been removed]
Hi,
En la db del ejemplo
http://sourceforge.net/mailarchive/message.php?msg_id=23092682
The messages table has several timestamp fields, but the field
(expired) is generating
the error.
Database: cabrweb.fdb, User: sysdba
SQL select expired from messages;
EXPIRED
Hello,
You could also do:
1. Disable all triggers and procedures. IBExpert lets you do it all at once
(Desactivate ALL Triggers/Store Procedures).
2. Delete or rename the UDF
2. Backup and Restore the DB.
3. Activate one by one and trigger procedures.
Regards.
PD: Sorry for my English :)
and...
SELECT '11'||IIF(12,'00', cast('' as varchar(1)))||'.22' FROM
rdb$database
Regards.
[Non-text portions of this message have been removed]
12 matches
Mail list logo
