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 entire script conditionally? Answer You
Tag: firebird
Display all Dates in a given month and year in firebird select procedure
I am making a program for Time and Attendance. I have a table with this fields here is the sample data and my desired output is this the time format of my desired output and my data is different and display the complete dates of the given month and year Answer You could solve this problem with a selectable stored
Convert columns to rows in Firebird (unpivot command)
Which is the similar command for unpivot in Firebird? TKS in advance… My Table Desired Result Answer You can use union all: Something like this should work for most purposes. EDIT: For your particular data:
Firebird SQL Statement to Get the Table Definition
I am writing my own Firebird database browser using the ibpp library. Is there a way I can get the table definition using an SQL statement? Answer Firebird does not support schemas, so there is no way you can get that information. The closest thing might be the owner, which you can get by querying RDB$RELATIONS Edit A “schema” is
Generate insert SQL statements from a CSV file
I need to import a csv file into Firebird and I’ve spent a couple of hours trying out some tools and none fit my needs. The main problem is that all the tools I’ve been trying like EMS Data Import and Firebird Data Wizard expect that my CSV file contains all the information needed by my Table. I need to