SELECT *
FROM RDB$USER_PRIVILEGES
WHERE RDB$USER = 'le_nom_de_role_à_créer'

Unable to complete network request to host XYZ.<br/>
Failed to locate host machine. <br/>
The specified name was not found in the hosts file or Domain Name Services.<br/>

ping XYZ

Token unknown - line X, char Y [

CREATE TRIGGER ...
ACTIVE BEFORE INSERT OR UPDATE OR DELETE ...
AS
BEGIN
IF (INSERTING) THEN NEW.quelquechose = 10;
if (DELETING AND OLD.quelquechose = 10) then ...
etc....
END

Terminating on exception I/O error 28

Statement failed, SQLCODE = -901 invalid BLOB ID

Secondary server attachments cannot validate databases

gstat -header /path/to/database.fdb

Attributes force write, database shutdown

gfix -online /path/to/database.fdb

Operating system directive open failed

drwxrwx--- 2 firebird firebird 1136 2007-05-31 18:21 databases/

-rw-rw---- 1 firebird firebird 6123520 2007-05-14 14:49 database.fdb

gsec -database path -mo username -pw new_password -user sysdba -pass masterkey

/opt/firebird/bin/gsec -database localhost:/opt/firebird/security.fdb -mo sysdba -pw monmdp -user sysdba -pass masterkey

SELECT *
FROM employee e
WHERE e.emp_no = (SELECT p.emp_no FROM employee_project p);

SELECT *
FROM employee e
WHERE e.emp_no = (SELECT FIRST 1 p.emp_no FROM employee_project p);

SELECT *
FROM employee e
WHERE e.emp_no IN (SELECT p.emp_no FROM employee_project p);

-- Ou , plus efficacement :

SELECT *
FROM employee e
WHERE EXISTS (SELECT 1 FROM employee_project p WHERE e.emp_nO = p.emp_no);

-- Ou, encore mieux :

SELECT e.*
FROM employee e
JOIN employee_project p ON e.emp_nO = p.emp_no;

SELECT e.*
FROM employee e
WHERE e.emp_no IN (SELECT p.emp_no FROM employee_project p WHERE p.proj_id= 8);

-- Ou , plus efficacement :

SELECT e.*
FROM employee e
WHERE EXISTS (SELECT 1 FROM employee_project p WHERE p.proj_id= 8 AND p.emp_no = e.emp_no);

-- Qui peut être aussi écrit :

SELECT e.*
FROM employee e
JOIN employee_project p on p.emp_no = e.emp_no
WHERE p.proj_id = 8;

SET NAMES WIN1252;

ID VALEUR
-- -----
10 15000

UPDATE t1 SET valeur = valeur + 20 WHERE id = 10;

CREATE VIEW extreeme_employee (first_name, job_grade)
AS
SELECT 'Confidentiel', job_grade
FROM employee
WHERE job_grade = (SELECT MAX(job_grade) FROM employee)

UNION

SELECT first_name, job_grade
FROM employee
WHERE job_grade = (SELECT MIN(job_grade) FROM employee);

CREATE VIEW extreeme_employee (first_name, job_grade)
AS
SELECT first_name, job_grade
FROM Employee
WHERE job_grade = (SELECT MAX(job_grade) FROM employee)

UNION ALL

SELECT first_name, 0
FROM employee
WHERE job_grade = 0;

localhost:C:\Chemin\vers\base.fdb

C:\chemin\vers\base.fdb

function ib_util_malloc(l: integer): pointer; cdecl; external 'ib_util.dll';

function ChangerMaChaine(const p: PChar): PChar; cdecl;
var
s: string;
begin
s := FaireQuelquechose(string(p));
Result := ib_util_malloc(Length(s) + 1);
StrPCopy(Result, s);
end;

DECLARE EXTERNAL FUNCTION F_ChangerMaChaine
CString(255)
RETURNS CString(255) FREE_IT
ENTRY_POINT 'ChangeMaChaine' MODULE_NAME '......'

SELECT id, MAX(date_modification)
FROM t1
WHERE MAX(date_modification) > current_timestamp
GROUP BY id;

SELECT id, MAX(date_modification)
FROM t1
GROUP BY id
HAVING MAX(date_modification) > current_timestamp;

CAST(valeur1 AS NUMERIC(18,3)) * CAST(valeur2 AS NUMERIC(18,3))

CAST(CAST(valeur1 AS DOUBLE PRECISION) * CAST(valeur2 AS DOUBLE PRECISION) AS NUMERIC(18,6))

ALTER INDEX [index name] INACTIVE;
ALTER INDEX [index name] ACTIVE;

gds_db 3050/tcp fb #Firebird

gds_db 3050/tcp # Firebird

INSERT INTO t1(x) VALUES (10)

INSERT INTO t1(x) VALUES (10);

INSERT INTO t1(x) VALUES (10);
COMMIT;

CREATE VIEW EV(EMP_NO)
AS
SELECT FIRST 10 EMP_NO
FROM EMPLOYEE;

dave@randoms:/opt/firebird/bin$ ldd fb_inet_server | grep icu
libicuuc.so.30 => /opt/firebird/lib/libicuuc.so.30 (0xb787d000)
libicudata.so.30 => /opt/firebird/lib/libicudata.so.30 (0xb7737000)
libicui18n.so.30 => /opt/firebird/lib/libicui18n.so.30 (0xb76f9000)

/opt/firebird/bin/fbmgr -start

/opt/firebird/bin/fbmgr -start -forever

/opt/firebird/bin/fbmgr -shut -user SYSDBA -pass *****

/opt/firebird/bin/fbmgr -shut -force -user SYSDBA -pass *****