[firebird-support] GSEA / Admin

2014-10-14 Thread 'Alan McDonald' a...@meta.com.au [firebird-support]
If I execute GSEC, then issue: modify USERNAME -admin yes [no response] Display USERNAME admin is not switched on If, on the other hand, I execute, at the command prompt: gsec -user SYSDBA -password masterkey -mo USERNAME -admin yes [no response] display USERNAME admin is now switched o

[firebird-support] Re: Backups and the Delta File

2014-10-14 Thread russ...@smxi.com [firebird-support]
Thanks for responding so quickly. I'm working with a framework set up by someone else which is obviously not behaving well. If I do a gbak I assume that takes the delta into account as well (it seems to). If I then restore from the gbak, should I delete the delta? (the database is offline

Re: [firebird-support] Backups and the Delta File

2014-10-14 Thread Kjell Rilbe kjell.ri...@datadia.se [firebird-support]
russ...@smxi.com [firebird-support] skrev: We have a large database that runs a full nbackup every night and an hourly incremental backup. Is the full backup meant to clear the delta file? this doesn't seem to get any smaller. Also if I restore a gbak backup, what should I do with the delta fi

Re: [firebird-support] Re: BLOB

2014-10-14 Thread Ivan Arabadzhiev intelru...@yahoo.com [firebird-support]
The fbsvcmgr method requires fb 2.5.2. The upside is you can run it remotely :) 2014-10-14 10:01 GMT+03:00 'Marius Labuschagne' mjlabuscha...@turnkey-is.co.za [firebird-support] < firebird-support@yahoogroups.com>: > > > From: firebird-support@yahoogroups.com [mailto: > firebird-support@yahoogrou

Re: [firebird-support] How do I return an accurate COUNT(*) when a JOIN is involved?

2014-10-14 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
Good morning SET. ;) I thought of the concatenation trick, but found it ugly as a solution, your second query is cleaner, I think. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBa

RE: [firebird-support] How do I return an accurate COUNT(*) when a JOIN is involved?

2014-10-14 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
>ACCT_CASE: Case Management table >ACCT_IDINTEGER    NOT NULL    PK >CASE_ID    SMALLINT    NOT NULL    PK >CLT_ID    INTEGER    NOT NULL    FK to CLIENT table  << Need this for the JOIN   >DEBTOR_CASE_DEBT:  Allows for multiple PERSON's to be associated with a DEBT >ACCT_IDINTEGER    NOT N