Re: [firebird-support] Re: Unsuccessful execution on delete FB 3 SP source code

2019-06-13 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
no error now thanks On Thursday, June 13, 2019, 4:41:12 PM GMT+3, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote:   13.06.2019 13:43, 'Mr. John' mr_joh...@yahoo.com wrote: > Using FB 3.0.4/Windows 10x64 ,I'm trying to delete SP source code as > worked in 2.

AW: [firebird-support] CTE, tricky request

2019-06-13 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
...perhaps a solution? union all select cast(a.t || b.str as timestamp) as ts, a.bez from tkal_main a, sub_datum(:vorschau) as b where a.serie = 2 create procedure SUB_DATUM ( days integer) returns ( str varchar(8)) as declare variable c_date timestamp; declare variable t_date ti

[firebird-support] CTE, tricky request

2019-06-13 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
Hello, I would like to generate a list with appointments. In a table tkal_main I set the day (field "t") of the meeting, every month I would like to get an entry. The description of the appointment is "bez". I helps me with a separate table (tmonate, id 1 = January and so on). Wit

[firebird-support] Re: Unsuccessful execution on delete FB 3 SP source code

2019-06-13 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
13.06.2019 13:43, 'Mr. John' mr_joh...@yahoo.com wrote: > Using FB 3.0.4/Windows 10x64 ,I'm trying to delete SP source code as > worked in 2.5: >       UPDATE RDB$PROCEDURES SET RDB$PROCEDURE_SOURCE = NULL WHERE > RDB$SYSTEM_FLAG IS NULL  OR RDB$SYSTEM_FLAG=0; > > bun now on FB 3 tried: > > u

[firebird-support] Unsuccessful execution on delete FB 3 SP source code

2019-06-13 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Using FB 3.0.4/Windows 10x64 ,I'm trying to delete SP source code as worked in 2.5:      UPDATE RDB$PROCEDURES SET RDB$PROCEDURE_SOURCE = NULL WHERE RDB$SYSTEM_FLAG IS NULL  OR RDB$SYSTEM_FLAG=0; bun now on FB 3 tried: update RDB$PROCEDURES set rdb$procedure_source = NULL where rdb$procedure_nam