How do I get this to work? Answer To escape an apostrophe you need to double it see manual
Tag: firebird2.5
Avoid duplicate values using join with multiple tables in Firebird
I have 3 tables Payments PaymntID Date Amount 1 Ago.2021 500 2 Sep.2021 1200 3 Oct.2021 600 CashPayments PaymntID Amount 1 500 2 400 3 200 CreditCardPayments PaymntID Amount CreditCard 2 450 Visa 2 350 MC 3 400 Visa I need to get the PaymentID, date, amount payed in cash and amount payed in creditcard, but wi…
Summarize unique column in row
I’m new to Firebird and need your help. I have a stored procedure with following reduced output: Player Team Number Reus Ahlen 18 Lewandowski Posen 19 Reus MG 11 Reus BVB 11 Lewandowski BVB 9 Haaland BVB 9 I want to summarize the Players and transform Team&Number to a new column. The output should b…
Finding computed fields in Firebird 2.5
Computed fields are readonly. I need to find all such fields in specific table. This query solves this problem (returns info if column is computed or not): At least it looks like it solves it, but it seems that returned informations are incorrect. When RDB$UPDATE_FLAG is 0, its computed (readonly). But its 0 …
Select everything except rows with maxvalue in certain column
I have a table with data and I’m trying to select some values with lower value than maximum. I am using IBExpert, I need to do this in SQL because I am working on a Firebird database. My table looks like this: What I want is to select only rows with GRUPA values lower than maximum, here max value is
Can I programmatically exit a Firebird script
Consider the following script: The exit is perfectly valid and does cause script execution to end. At least in IBExpert where I am testing this. But I want to do this programmatically. Is the exit in my first example valid Firebird or is IBExpert handling this itself? Is there a different way to exit the enti…