Re: [firebird-support] How to change Primary Key on a table by adding a new field

2015-01-27 Thread Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
Hello Bogdan, thanks for your suggestion. By ZeosLib TSQLProcessor, I try this: -- SET TERM !!; EXECUTE BLOCK RETURNS (stmt VARCHAR(1000)) AS BEGIN FOR SELECT 'ALTER TABLE MYTABLE DROP CONSTRAINT ' || rdb$constraint_name from rdb$relation_constraints where

Re: [firebird-support] Function - what is it called

2015-01-27 Thread Charles Hudson clh...@gmail.com [firebird-support]
In MS and Oracle dialects this would be accomplished with a ROLLUP or CUBE statement. On Tue, 2015-01-27 at 08:17 +1300, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: At 11:25 p.m. 23/01/2015, michael.vilhelm...@microcom.dk [firebird-support] wrote: I am looking for a

Re: [firebird-support] Re: Unicode text in Exception?

2015-01-27 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
btw, in Firebird 3, the RDB$EXCEPTIONS.RDB$MESSAGE is still NONE. Would it make sense to encode the message according to the given connection character set? Now, I tried the following in the procedure to work around the above: exception test _utf8 'unicode string here'; Any idea why this