Re: [firebird-support] How to fill detail table with record secuence into master table

2016-01-23 Thread setysvar setys...@gmail.com [firebird-support]
Or (if he wants a number starting from 1 for each master, as opposed to a unique number for each master): execute block as declare mId integer; declare mOld integer; declare dId integer; declare dmId integer; begin m_Old = -1; dmId = 1; for select id, master_id from

[firebird-support] Re: How to fill detail table with record secuence into master table

2016-01-23 Thread duque.herna...@yahoo.com [firebird-support]
Thank you very much for your posts. Both examples are very valuable. Anyway what I need is to start from 1 for each master. Best regards. Hernando.

[firebird-support] Page is of wrong type (expected 5, found 0)

2016-01-23 Thread Martin Schwedhelm silo...@yahoo.com [firebird-support]
Hi all, I have multiple (8) databases where no connection is possible and gfix prints the above message. Firebird version: 2.5.2Operating system: Windows 2003 - Windows 2008 (VmWare)Size: Varying, ~100MB to ~14GB single fileODS: 11.1 / 11.2 It looks like the database file is truncated and when

Re: [firebird-support] Page is of wrong type (expected 5, found 0)

2016-01-23 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Sat, Jan 23, 2016 at 9:41 AM, Martin Schwedhelm silo...@yahoo.com [firebird-support] wrote: > > > I have multiple (8) databases where no connection is possible and gfix > prints the above message. > > Firebird version: 2.5.2 > Operating system: Windows 2003 -