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_nameSTARTING WITH 'MYPR_'
and got Unsuccessful execution caused by a system error that precludes 
successful execution of subsequent statements.UPDATE operation is not allowed 
for system table RDB$PROCEDURES.
that seems to be fixed:  [#CORE-4507] Unable delete procedure source on 
Firebird 3.0 Alpha 2.0 - Firebird RDBMS Issue Tracker

| 
| 
| 
|  |  |

 |

 |
| 
|  | 
[#CORE-4507] Unable delete procedure source on Firebird 3.0 Alpha 2.0 - ...


 |

 |

 |



Dmitry Yemanov 
"The ability to explicitly set the source code to NULL is restored. All other 
kinds of direct modifications are still prohibited"

but not workingthanks for any help
  • [firebird-s... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
    • [fireb... Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
      • Re... 'Mr. John' mr_joh...@yahoo.com [firebird-support]

Reply via email to