[firebird-support] Re: BLOB

I ran some tests : A. "D:\Program Files (x86)\Firebird\Firebird_2_5\bin\gbak.exe" -b -g -v -service xx.xx.xx.14:service_mgr -user sysdba -password masterkey e:\fdb\gestoc_asolo.fdb gestoc_asolo.fbk B. "D:\Program Files (x86)\Firebird\Firebird_2_5\bin\fbsvcmgr.exe" xx.xx.xx.14:serv

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

Hi, I do not follow whole discussion but what problem you see in Select count(field1 ¦¦ '_' ¦¦ field2) from ... You can include more fields Regards, Karol Bieniaszewski Wysłane z mojego HTC - Reply message - Od: "'Softtech Support' stwiz...@att.net [firebird-support]" Do: Temat: [fi

RE: [firebird-support] Firebird v2.5 running Classic mode

> Taskkill will be ok if no one user worked with yours database and no internal > process worked with your database. And it's not OK when you have more > than one database on such server, because you interrupt working sessions to > another databases. All of which will not corrupt a database if F

[firebird-support] Unable to create database

I'm using Firebird 2.5.2 and on the machine in question have created two databases late last year. Using Isql, I put the CREATE SCHEMA in with credentials and get this message back. Statement failed, SQLSTATE = 08006 connection lost to database Note that I can query the other two Dbs, ru

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

Hello Mike, No doubt our favorite SQL wizard from Norway, SET, will join in, perhaps he has an idea. As for my answer with the VIEW, now that I think of it, you would need the date and status columns as well, so the DISTINCT is different. Darn. You could use a SELECT-able Stored Procedure, ret

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

Hi Martijn, I want to count the number of records in the DEBTOR_CASE_DEBT table (not DEBT) where the ACCT_ID, CASE_ID and DEBT_NO are distinct and specific to CLT_ID. Is this possible in v1.5.3? If not and I need to create a view and COUNT() that, can you provide an example or tell me where to

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

Hello Mike, So you want to count records in DEBT for a specific CLT_ID. Now, in the DEBT table, there are records for multiple PERSONs, but what about ACCT_ID, CASE_ID and DEBT_NO, which of these or what combination are unique with regard to each ACCT_CASE? If none, you would need a derived ta

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

Hi Martijn, I knew I was going to get in trouble by not providing enought information as I thought by proving less it would be just a little bit clearer to understand, my bad... Let's start over with an simplified explanation of the tables: ACCT_CASE: Case Management table ACCT_IDINTEGER

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

Hello Mike, >Just happening to be testing this in Database Workbench. Have used this >product for years and just love it. Thank you, that’s good to hear. >Thanks for you reply. > >So my second SQL should have been as follows? It results in an error "Dynamic >SQL Error SQL error code = -104

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

Greetings Martijn, Just happening to be testing this in Database Workbench. Have used this product for years and just love it. Thanks for you reply. So my second SQL should have been as follows? It results in an error "Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 34 ,

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

Hello Mike, In the second query, you’re counting records and then do the DISTINCT, so the result is 32, and if you “distinct” that result, there’s only 1 record, with a value of 32. What you seem to want, is to COUNT(DISTINCT(...)) With regards, Martijn Tonies Upscene Productions http://www.up

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

Greetings All, Firebird 1.5.3 (Yes I know it is old) Using the following syntax with 09/01/14 and 09/04/14 for the parameters fetches 20 distinct records SELECT DISTINCT DCD.ACCT_ID, AC.CLT_ID FROM DEBTOR_CASE_DEBT DCD JOIN ACCT_CASE AC ON AC.ACCT_ID = DC

Re: [firebird-support] Firebird v2.5 running Classic mode

Taskkill will be ok if no one user worked with yours database and no internal process worked with your database. And it's not OK when you have more than one database on such server, because you interrupt working sessions to another databases. I corrupted databases very well with such method. I

RE: [firebird-support] Firebird v2.5 running Classic mode

> If you execute taskkill /IM fb_inet_server.exe /F then you are kill your > database(broken indexes, missing data or some else things. if autosweep is > on, you may completely kill your database). Not true at all! We use taskkill all of the time to force a shutdown of FB instances when we nee

Re: [firebird-support] Firebird v2.5 running Classic mode

If you execute taskkill /IM fb_inet_server.exe /F then you are kill your database(broken indexes, missing data or some else things. if autosweep is on, you may completely kill your database). If your users is not sysdba or owner of database use shutdown mode, this method rollback all transaction

[firebird-support] Firebird v2.5 running Classic mode

What is the best way to disconnect and end all user connections to a FB v2.5 database running in Classic mode on a Windows server? This will only occur when an update is being applied, so users will have advanced notice not to be using the database. I've been told I can just run the taskkill /I

Re: [firebird-support] BLOB

Better yet, use fbsvcmgr remotehost:service_mgr -user sysdba -password XXX action_backup -dbname some.fdb -bkp_file stdout >some.fbk 2014-10-13 16:18 GMT+03:00 Thomas Steinmaurer t...@iblogmanager.com [firebird-support] : > > > > > > > > > I run the backup automatically each night (Windows s

Re: [firebird-support] BLOB

> > I run the backup automatically each night (Windows scheduled tasks), for > a few of my customers, via the Internet. Ok, even worse. > And yes, I need the backup file locally, on my system. > > As I mentioned before, if the backup lasts for 10 minutes of which > log_tables takes 9 , no prob

Re: [firebird-support] BLOB

Re: [firebird-support] BLOB

> I recorded the process of backup , if anybody would be so kind to help > me, please take a look at : > FireBirdBackup > > image > > > FireBirdBackup > This feature is not available rig

RE: [firebird-support] BLOB

I recorded the process of backup , if anybody would be so kind to help me, please take a look at : FireBirdBackup http://youtu.be/txUruy35qHE http://youtu.be/txUruy35qHE FireBirdBackup http://youtu.be/txUruy35qHE This feature is not available right now. Please try again later.

RE: [firebird-support] BLOB

>>Text, binary, it's all the same to gbak.   Try the -g suggestion - if gbak is >>cleaning out garbage, it's slow. > >But, surely, the garbage has to be cleaned out sooner or later, and doing it >in a backup run is the cheapest way to do it, >as every record is being visited anyway? (Compared to

Re: [firebird-support] BLOB

On 10/10/2014 22:22, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: Text, binary, it's all the same to gbak. Try the -g suggestion - if gbak is cleaning out garbage, it's slow. But, surely, the garbage has to be cleaned out sooner or later, and doing it in a backup run is t