Hello,
May be you build an empty Fb2.5 database with the same structure (Tables,
Generators…)Export the FB3 datas into SQL...Adapt the sql.. and execute them
into FB2.5...
With best regards,Mikey
Le mercredi 12 juin 2019 à 12:57:08 UTC+2, 'Mr. John' mr_joh...@yahoo.com
[firebird-support] <firebird-support@yahoogroups.com> a écrit :
I've extracted db into a script,but when restoring got almost the same error:
Invalid token.Dynamic SQL Error.SQL error code = -104.Token unknown - line 1,
column 36.START.
error is on every generator code:
CREATE GENERATOR GEN_HT_MENT_ID START WITH 0 INCREMENT BY 1;
SET GENERATOR GEN_HT_MENT_ID TO 1;
in my app I have no such code,for generators I used this:
CREATE GENERATOR GEN_HT_MENT_ID;SET GENERATOR GEN_HT_MENT_ID TO 1;
thanks
thanks
On Wednesday, June 12, 2019, 1:25:40 PM GMT+3, Dimitry Sibiryakov
s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> wrote:
12.06.2019 12:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> what other way I could use?
Create database from scratch, pump data.
--
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
#yiv7025946912 #yiv7025946912 -- #yiv7025946912ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7025946912
#yiv7025946912ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7025946912
#yiv7025946912ygrp-mkp #yiv7025946912hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7025946912 #yiv7025946912ygrp-mkp #yiv7025946912ads
{margin-bottom:10px;}#yiv7025946912 #yiv7025946912ygrp-mkp .yiv7025946912ad
{padding:0 0;}#yiv7025946912 #yiv7025946912ygrp-mkp .yiv7025946912ad p
{margin:0;}#yiv7025946912 #yiv7025946912ygrp-mkp .yiv7025946912ad a
{color:#0000ff;text-decoration:none;}#yiv7025946912 #yiv7025946912ygrp-sponsor
#yiv7025946912ygrp-lc {font-family:Arial;}#yiv7025946912
#yiv7025946912ygrp-sponsor #yiv7025946912ygrp-lc #yiv7025946912hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7025946912
#yiv7025946912ygrp-sponsor #yiv7025946912ygrp-lc .yiv7025946912ad
{margin-bottom:10px;padding:0 0;}#yiv7025946912 #yiv7025946912actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7025946912
#yiv7025946912activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7025946912
#yiv7025946912activity span {font-weight:700;}#yiv7025946912
#yiv7025946912activity span:first-child
{text-transform:uppercase;}#yiv7025946912 #yiv7025946912activity span a
{color:#5085b6;text-decoration:none;}#yiv7025946912 #yiv7025946912activity span
span {color:#ff7900;}#yiv7025946912 #yiv7025946912activity span
.yiv7025946912underline {text-decoration:underline;}#yiv7025946912
.yiv7025946912attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7025946912 .yiv7025946912attach div a
{text-decoration:none;}#yiv7025946912 .yiv7025946912attach img
{border:none;padding-right:5px;}#yiv7025946912 .yiv7025946912attach label
{display:block;margin-bottom:5px;}#yiv7025946912 .yiv7025946912attach label a
{text-decoration:none;}#yiv7025946912 blockquote {margin:0 0 0
4px;}#yiv7025946912 .yiv7025946912bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7025946912
.yiv7025946912bold a {text-decoration:none;}#yiv7025946912 dd.yiv7025946912last
p a {font-family:Verdana;font-weight:700;}#yiv7025946912 dd.yiv7025946912last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7025946912
dd.yiv7025946912last p span.yiv7025946912yshortcuts
{margin-right:0;}#yiv7025946912 div.yiv7025946912attach-table div div a
{text-decoration:none;}#yiv7025946912 div.yiv7025946912attach-table
{width:400px;}#yiv7025946912 div.yiv7025946912file-title a, #yiv7025946912
div.yiv7025946912file-title a:active, #yiv7025946912
div.yiv7025946912file-title a:hover, #yiv7025946912 div.yiv7025946912file-title
a:visited {text-decoration:none;}#yiv7025946912 div.yiv7025946912photo-title a,
#yiv7025946912 div.yiv7025946912photo-title a:active, #yiv7025946912
div.yiv7025946912photo-title a:hover, #yiv7025946912
div.yiv7025946912photo-title a:visited {text-decoration:none;}#yiv7025946912
div#yiv7025946912ygrp-mlmsg #yiv7025946912ygrp-msg p a
span.yiv7025946912yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7025946912
.yiv7025946912green {color:#628c2a;}#yiv7025946912 .yiv7025946912MsoNormal
{margin:0 0 0 0;}#yiv7025946912 o {font-size:0;}#yiv7025946912
#yiv7025946912photos div {float:left;width:72px;}#yiv7025946912
#yiv7025946912photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv7025946912
#yiv7025946912photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7025946912
#yiv7025946912reco-category {font-size:77%;}#yiv7025946912
#yiv7025946912reco-desc {font-size:77%;}#yiv7025946912 .yiv7025946912replbq
{margin:4px;}#yiv7025946912 #yiv7025946912ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7025946912 #yiv7025946912ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7025946912
#yiv7025946912ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7025946912
#yiv7025946912ygrp-mlmsg select, #yiv7025946912 input, #yiv7025946912 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7025946912
#yiv7025946912ygrp-mlmsg pre, #yiv7025946912 code {font:115%
monospace;}#yiv7025946912 #yiv7025946912ygrp-mlmsg *
{line-height:1.22em;}#yiv7025946912 #yiv7025946912ygrp-mlmsg #yiv7025946912logo
{padding-bottom:10px;}#yiv7025946912 #yiv7025946912ygrp-msg p a
{font-family:Verdana;}#yiv7025946912 #yiv7025946912ygrp-msg
p#yiv7025946912attach-count span {color:#1E66AE;font-weight:700;}#yiv7025946912
#yiv7025946912ygrp-reco #yiv7025946912reco-head
{color:#ff7900;font-weight:700;}#yiv7025946912 #yiv7025946912ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7025946912 #yiv7025946912ygrp-sponsor
#yiv7025946912ov li a {font-size:130%;text-decoration:none;}#yiv7025946912
#yiv7025946912ygrp-sponsor #yiv7025946912ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7025946912
#yiv7025946912ygrp-sponsor #yiv7025946912ov ul {margin:0;padding:0 0 0
8px;}#yiv7025946912 #yiv7025946912ygrp-text
{font-family:Georgia;}#yiv7025946912 #yiv7025946912ygrp-text p {margin:0 0 1em
0;}#yiv7025946912 #yiv7025946912ygrp-text tt {font-size:120%;}#yiv7025946912
#yiv7025946912ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7025946912
