Re: [firebird-support] Converting with parameters stored in variables?

select right('0'||(10.3+0.000),10) from rdb$database Hello,   I get from a application the following   100 R10.3 Or 22.22 R10.3   Now I should take it into:   000100.000 And 22.220   I think, I cannot simply (cast :input as :vartype) (vartype =

Re: [firebird-support] Firebird ins't updating date/time automatically

select cast('Now' as time) from rdb$database My clients are 24/7 and when daylight save starts automatically in Windows, CURRENT_TIMESTAMP continues returning the old date/time until the Firebird is restarted.

Re: [firebird-support] Two versions

same problem for windows ?

Re: [firebird-support] Problem in executing query using 'IN' statement.

On Friday, September 16, 2016 4:35 PM, "'Joje' j...@codework-solutions.com [firebird-support]" wrote:      AND Tb3.NAME _IDS IN  (CAST(Tb2.NAME_ID AS VARCHAR(250))) /*Here Tb3.NAME _IDS is varchar & Tb2.NAME _IDS is int so casted into varchar. This

Re: [firebird-support] Re: Connecting to Firebird database from two or more pc with same username

I hope I did do not a fixation by "on connect"  :D SET TERM ^ ;ALTER TRIGGER USER_ON ACTIVEON CONNECT POSITION 0AS   declare variable m_gaz varchar(25);BEGIN     select mon$remote_address from MON$ATTACHMENTS         where mon$attachment_id=current_connection        into :m_gaz;   

Re: [firebird-support] How can I prevent that my database can be opened with another security.fdb.

Suggestion event studies "on connect" 1. an application with minimum rights connects to the database 1 '. in table "mon$attachmnts" field "MON$REMOTE_PROCESS" will record the application name 2.  in the trigger event "on connect" if the user connects SysAdmin, verifies the application name in

Re: [firebird-support] how to suppress dashes in query results

SELECT * WHERE REPLACE(UsersField,'-') = 'MyValue' On Friday, February 12, 2016 3:57 AM, "ho...@agencybusys.com [firebird-support]" wrote: Users can enter values with dashes (-) in random locations. I don't know where they might put them. I need

Re: [firebird-support] How to manage tribbers BeforeUpdate and AfterUpdate for same table

 in a similar situation i uses RDB$SET_CONTEXT() and RDB$GET_CONTEXT() initialize  trigger  ON CONNECT On Monday, January 25, 2016 11:17 AM, "Luigi Siciliano luigi...@tiscalinet.it [firebird-support]" wrote: Hallo,   I Have a table with a column

Re: [firebird-support] How to fill detail table with record secuence into master table

set term #;execute block as     declare m_mId char(10);    -- type of master_id    declare m_dId integer;  -- type of detail_idbegin     m_dId=0; for select distinct master_id from detail        into :m_mId         do            begin                m_dId=m_dId+1;

Re: [firebird-support] Extract seconds from timestamp

select cast(extract(second from cast('12.12.2016 23:59:59:4900' as timestamp)) as integer) from rdb$database 59 On Wednesday, January 6, 2016 10:37 AM, "'Bogdan' bog...@mordicom.si [firebird-support]" wrote: Hi all  I wonder if this is an error

Re: [firebird-support] string difficulty

How can I get ABC*DEFG, leave the * between C*D, delete all * from right? SET TERM ^ ;CREATE PROCEDURE DEL_CHAR (    M_SIR varchar(500),    M_CHAR varchar(10) )RETURNS (    M_STR varchar(500) )AS    declare ii smallint;     declare iy smallint;BEGIN    m_str='';    iy=char_length(m_sir);   

Re: AW: [firebird-support] string difficulty

a quick answer : m_char='**' On Monday, December 7, 2015 12:12 PM, "'checkmail' check_m...@satron.de [firebird-support]" wrote: But If the ID is ABC*DEFG, I get ABC*DEFG01 and in this case only all * from right should be deleted.  I have

Re: AW: [firebird-support] string difficulty

sorry, wrong response :( On Monday, December 7, 2015 12:22 PM, "Virna Constantin costel...@yahoo.com [firebird-support]" <firebird-support@yahoogroups.com> wrote: #yiv0072394990 #yiv0072394990 -- #yiv0072394990 .yiv0072394990ygrp-photo-title{clear:both;font-size:sma

Re: AW: [firebird-support] string difficulty

select replace('ABC*DEFG01','**','') from RDB$DATABASE On Monday, December 7, 2015 12:26 PM, "Virna Constantin costel...@yahoo.com [firebird-support]" <firebird-support@yahoogroups.com> wrote: #yiv7701085015 #yiv7701085015 -- #yiv7701085015 .yiv7701085015

Re: [firebird-support] Using LIKE/MATCHING? in stored procedure

SELECT PRODUCTIONLINENR FROM TBLPRODUCTIONLINE WHERE Position(  :ESXPRODUCTIONLINE||';' IN Trim(ESXKEY)||';')0 into :PRODUCTIONLINENR; On Wednesday, August 5, 2015 2:36 PM, Scott Morgan bl...@blueyonder.co.uk [firebird-support] firebird-support@yahoogroups.com wrote: On 05/08/15

Re: [firebird-support] Request new feature - better perfomance

“b on a.something = a.something” produce an error. a.something=b.something !!! another option: select a.someting, a.anotherthing, b.total from first a inner join ( select someting,sum(thirdhing) as total from second group by someting having sum(thirdhing)10 ) b on

Re: [firebird-support] Request new feature - better perfomance

“b on a.something = a.something” produce an error. a.something=b.something !!! another option: select a.someting, a.anotherthing, b.total from first a inner join ( select someting,sum(thirdhing) as total from second group by someting having sum(thirdhing)10 ) b on

Fw: [firebird-support] Request new feature - better perfomance

Maybe I was not clear as I should be but here is an example in Firebird: select something,anotherthing,(select sum(thirdthing) from second b where b.something = a.something) total from a where (select sum(thirdthing) from second b where b.something = a.something) 10 tray sentence:

Re: [firebird-support] Create Date of Database Object

table: MON$DATABASE field: MON$CREATION_DATE On Monday, August 4, 2014 1:17 PM, 'Marius Labuschagne' mjlabuscha...@turnkey-is.co.za [firebird-support] firebird-support@yahoogroups.com wrote: Hi,   Is it possible to see from the systems tables when a database object was created?   For

Re: [firebird-support] Create Date of Database Object

On Monday, August 4, 2014 2:06 PM, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] firebird-support@yahoogroups.com wrote: Hi,   Is it possible to see from the systems tables when a database object was created?   For instance I want to try and find out