Re: [firebird-support] Column Unknown FB 1.5->2.5

2014-05-08 Thread Thomas Beckmann
One thing, that corresponds to Seans ideas: Formely you could used mixed alias and table name in field list. Now, you've to be strict: Assign alias and use alias (or no qualifier) or do not assign alias. I.e.: select t.C from tab t -- works select tab.C from tab -- works select C from tab

RE: [firebird-support] Column Unknown FB 1.5->2.5

2014-05-08 Thread Leyne, Sean
> I have a legacy client that was running fine on XP with FB 1.5 but we've > recently switched the PC out for a Win7 Pro 64 bit system. > > In order to get the client running on the Win7 system I installed FB 2.5 on it > and used gbak on the new system to restore the database file as a 2.5 > ver

RE: [firebird-support] NBackup Levels

2014-05-08 Thread Leyne, Sean
> From a quick search, I suspect that will be the "pag_scn" 4 byte value. I don't recall exactly, if you want to pursue this you should ask on the Devel list for confirmation. > That would mean that I could relatively easily write my own sync code that > could also read all those values and de

[firebird-support] Re: Column Unknown FB 1.5->2.5

2014-05-08 Thread srotyliano
One other bit... I didn't use the -TRANSPORTABLE switch when I created the backup file on the 1.5 system Could this have something to do with the error ?

[firebird-support] Column Unknown FB 1.5->2.5

2014-05-08 Thread srotyliano
I have a legacy client that was running fine on XP with FB 1.5 but we've recently switched the PC out for a Win7 Pro 64 bit system. In order to get the client running on the Win7 system I installed FB 2.5 on it and used gbak on the new system to restore the database file as a 2.5 version (i

AW: [firebird-support] NBackup Levels

2014-05-08 Thread Steffen Heil (Mailinglisten)
Hi > Correct, but that information is actually stored as a "version number" in the > header of each data page. When page data changes the "version number" is changed. > The nbackup database structure only stores the "version number" for the > backup level. >From a quick search, I suspect that

RE: [firebird-support] NBackup Levels

2014-05-08 Thread Leyne, Sean
> But as far as I understand, the database has to track which page changes > since which backup. Correct, but that information is actually stored as a "version number" in the header of each data page. When page data changes the "version number" is changed. The nbackup database structure only

AW: [firebird-support] NBackup Levels

2014-05-08 Thread Steffen Heil (Mailinglisten)
Hi > > Is there a negative effect on too many levels? > > (Slowdown or database storage overhead?) > No negative effect. > The database does track the ID of the last backup at each level, so you would > have 2 or 3 more entries that the typical usage, but the details are notional in size. But a