Re: [firebird-support] FB 3 - Adding anew User

2016-06-13 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Hello fabia...@itbizolutions.com.au, Tuesday, June 14, 2016, 1:49:30 PM, you wrote: > Sorted after reading "Initializing the Security Database" from > http://www.firebirdsql.org/file/documentation/release_notes/Firebird-3.0.0-ReleaseNotes.pdf > at page 116. I think there is a small error on

Re: [firebird-support] FB 3 - Adding anew User

2016-06-13 Thread fabia...@itbizolutions.com.au [firebird-support]
Sorted after reading "Initializing the Security Database" from http://www.firebirdsql.org/file/documentation/release_notes/Firebird-3.0.0-ReleaseNotes.pdf at page 116. I think there is a small error on the documentation, where it says " isql -user sysdba employee", the sentence works probably

RE: [firebird-support] How does one connect to Firebird 2.5.4 that is on a windows server from a linux client?

2016-06-13 Thread 'stwizard' stwiz...@att.net [firebird-support]
Yes I have, about 6 months ago I went through the entire guide. I went back and looked just now and directed the user to look at the Working with Databases section of the quick start guide. I hope it is what he is needing. I know nothing about Linux. Thanks, Mike Have you read Fireburd

Re: [firebird-support] How does one connect to Firebird 2.5.4 that is on a windows server from a linux client?

2016-06-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.06.2016 20:37, 'stwizard' stwiz...@att.net [firebird-support] wrote: > Can anyone share information or a link on how that can be done? Have you read Fireburd Quick Start Guide? -- WBR, SD.

[firebird-support] How does one connect to Firebird 2.5.4 that is on a windows server from a linux client?

2016-06-13 Thread 'stwizard' stwiz...@att.net [firebird-support]
I have one person in our office that uses a Linux work station that wants to connect to our Firebird database v 2.5.4 that is on a Windows 2012 Server. Can anyone share information or a link on how that can be done? I would really appreciate any help. Thanks, Mike

RE: [firebird-support] Query with few reads is slower than query with many reads. Which query to choose?

2016-06-13 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
> I am trying select contracts together with the contract lines. around 30.000 > contracts and around 800.000 contract lines.  And I have two queries that to > essentially the same (each contract has at least one contract_line): ... > All the reads of both queries are indexed reads. > > The

[firebird-support] Query with few reads is slower than query with many reads. Which query to choose?

2016-06-13 Thread jonatan.laurit...@yahoo.dk [firebird-support]
I am trying select contracts together with the contract lines. around 30.000 contracts and around 800.000 contract lines. And I have two queries that to essentially the same (each contract has at least one contract_line): select c.id c.contract_date, (select sum(cl.amount)