Subject Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5
Author Mr. John
Post date 2019-06-12T10:20:58Z
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 sd@... [firebird-support] <firebird-support@yahoogroups.com> wrote:


12.06.2019 11:38, 'Mr. John' mr_johnmr@... [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

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-support-digest@yahoogroups.com
    firebird-support-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    firebird-support-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/us/yahoo/utos/terms/