sql,firebird,jointable,firebird2.1
You can't. In Firebird you can only join tables in the same database file. Firebird 2.5 expanded EXECUTE STATEMENT to also execute a statement on an external datasource, but having a single query reference tables in different databases is not possible. You have the following options: Create a temporary table,...
linux,apache,cgi,freepascal,firebird2.1
I figured out how to get it working by reading the solution to a different problem. Not sure why disabling the firewall didn't work (I had to completely uninstall it) and don't know what SELinux is yet (had to set it to "permissive"), but I will need to study those...
c#,exception,entity-framework-6,firebird2.1
The generated uses @p__linq__1 IS NULL (which is actually sent as ? IS NULL to the server), and this was only introduced in Firebird 2.5. To be able to use this you either need to upgrade to Firebird 2.5, or handle the steel.HasValue condition in code and not in the...
Below is a very simple program that handles events, it was copied/modified from Firebird .NET - Examples of use. The class that handles the events is FbRemoteEvent. You register the event(s) you are interested in on an instance and you add event handler(s) to be notified when an event occurs....
DDL from PSQL is not allowed, using EXECUTE STATEMENT it is not directly forbidden, and usually possible, but still not wise exactly because of these kinds of problems. I am not exactly sure about the reasons, but part of it have to do with how DDL changes are applied in...
entity-framework-6,firebird2.1
The error suggests you are connecting using dialect 1. Dialect 1 is the old dialect of Interbase 5 and earlier and should be considered deprecated (although unfortunately 15 years on it is still supported by Firebird...). In dialect 1 it is not possible to quote object names, and double quotes...