hi the based application is written for 2.5 and then compiled for fb3,no new fb 3 field type or code,the only thing done is that new SP code protection/remove: update RDB$PROCEDURES set rdb$procedure_source = NULL where rdb$procedure_name STARTING WITH ....
instead of 2.5 UPDATE RDB$TRIGGERS SET RDB$TRIGGER_SOURCE = NULL WHERE RDB$SYSTEM_FLAG IS NULL OR RDB$SYSTEM_FLAG=0; UPDATE RDB$PROCEDURES SET RDB$PROCEDURE_SOURCE = NULL WHERE RDB$SYSTEM_FLAG IS NULL OR RDB$SYSTEM_FLAG=0; what other way I could use? thanks On Wednesday, June 12, 2019, 12:55:20 PM GMT+3, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> wrote: 12.06.2019 11:38, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > Invalid token. > invalid request BLR at offset 27. > BLR syntax error: expected valid BLR code at offset 28, encou ntered >210. This database obviously used some new features of Firebird 3 in stored code. It cannot be downgraded by backup-restore. Use other ways. -- WBR, SD. ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links