Re: [firebird-support] Doubt (Problem) In Writing SQL

Hi SET, Thank You for the reply. Not an issue, I could understand. Before I execute this SQL, would like to learn something pretty interesting logic in the SQL you provided. I got the intention of using Exists predicate but I couldn't understand the logic behind the below condition, would you

[firebird-support] How to get different Maximum Data for every single date in the table?

Hi All, As per the attache files or below specified table DDL, DML and SQL, I need to get below details: Get Order_ID, Order_Date, Salesman_ID for different Salesmen :1. Who sold maximum Copy for a day2. Who sold maximum amount of book for a day3. Who got maximum order for a day As per below

[firebird-support] Re: How to get different Maximum Data for every single date in the table?

HI SET, Please help. Thanks In Advance. With Best Regards. Vishal On Monday, 17 July 2017 4:04 PM, Vishal Tiwari wrote: Hi All, As per the attache files or below specified table DDL, DML and SQL, I need to get below details: Get Order_ID, Order_Date,

Re: [firebird-support] Connection rejected by remote interface

I have the same problem running Firebird super server on Linux ( Ubuntu 14.04 ). Sadly, the only solution I found was to restart Firebird service. I wrote a bash script that attempts to connect to the database. If it could not establish a connection, it restarts Firebird service. This

Re: [firebird-support] Rename table

Hi, This whole discussion is strange to me.Rename table while are pending inserts to it?How. If statment like rename table exsist then after name has changed all applications must be recompiled to take this new name into account. This looks to me that discussion is not about real problem. Only

Re: [firebird-support] Re: How to get different Maximum Data for every single date in the table?

On 17-7-2017 13:31, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > HI SET, > > Please help. I find it rather rude to expect (almost demand) someone to just help you, and to then ignore the fact that there are also other people here who would also might help you. Not to

Re: [firebird-support] Rename table

this was the solution I proposed in first instance. Else what's in a name ? , if not what the table contains ? The VCL BATCHMOVE does it fast a seemlessly in one click, if field names are the same or if different then use the EMS components !!! 2017-07-17 11:48

Re: [firebird-support] Connection rejected by remote interface

On 17-7-2017 14:08, Aldo Caruso aldo.car...@argencasas.com [firebird-support] wrote: > I have the same problem running Firebird super server on Linux ( > Ubuntu 14.04 ). Sadly, the only solution I found was to restart Firebird > service. > > I wrote a bash script that attempts to

Re: [firebird-support] Re: How to get different Maximum Data for every single date in the table?

Hi Mark, Kindly don't get me rude here. I always respected everyone in this group. Till today firebird is the only database I love a lot. About asking for the help, it was not actually demanding. In past, me and SET had lot of valuable conversation here. I just know two ppl here, Ms. Helen and

Re: [firebird-support] Re: How to get different Maximum Data for every single date in the table?

@Mark: I guess, asking for help, is never be like demanding. It is more over expecting cooperation according to me. But anyways no more talk on that issue... On Monday, 17 July 2017 9:32 AM, Vishal Tiwari wrote: Hi Mark, Kindly don't get me rude here. I

Re: [firebird-support] Connection rejected by remote interface

Hi Mark, the version number is 2.5.2. Unfortunately I cannot upgrade it to a more recent one because the OS is Ubuntu 14.04, and I have to wait until a complete migration to Ubuntu 16.04 until I can upgrade Firebird to a newer version. Thanks, Aldo Caruso El 17/07/17 a las 12:01,