Re: [firebird-support] Simple post edited data to table raises exception after converting FB 2.1 to FB 3.0

2017-07-20 Thread setysvar setys...@gmail.com [firebird-support]
Den 20.07.2017 16:53, skrev fredf...@hotmail.com [firebird-support]: I used Delphi's FireDAC components and FireDAC Monitor program which tracing issues with Firebird. I posted extracted data from tracing file after user hit save button to save changes in address1 line - it's very simple

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

2017-07-20 Thread setysvar setys...@gmail.com [firebird-support]
Den 17.07.2017 13:16, skrev Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]: 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

Re: [firebird-support] Simple post edited data to table raises exception after converting FB 2.1 to FB 3.0

2017-07-20 Thread fredf...@hotmail.com [firebird-support]
I used Delphi's FireDAC components and FireDAC Monitor program which tracing issues with Firebird. I posted extracted data from tracing file after user hit save button to save changes in address1 line - it's very simple transaction which failed in Firebird 3 and has no problem under Firebird

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

2017-07-20 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
You could add "Order_ID" in List() function in Firebird, for requirement 1 and two, but Order_Date and Salesman_ID must be displayed, as same Salesman could have multiple orders, so those could be displayed in one row separated by comma, which List() function does. On Tuesday, 18 July

Re: [firebird-support] Simple post edited data to table raises exception after converting FB 2.1 to FB 3.0

2017-07-20 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2017-07-20 00:18, fredf...@hotmail.com [firebird-support] wrote: > The error states: Exception class EFDDBEngineException with message > [FireDAC][Phys][FB_30]-312 Exact update affected [0] rows, while [1] > was requested. > If I hit "Continue" button then another exception raises: > The error