Re: Re[2]: [firebird-support] select column if it exists

What about: SELECT A, B, COALESCE(C, 'some value here') FROM MyTable Greetings. Walter. On Tue, Oct 10, 2017 at 2:56 PM, 'Daniel Miller' dmil...@amfes.com [firebird-support] wrote: > > > I don't think you could express it in the SELECT directly

Re: [firebird-support] detect if database has changed

There are several ways for doing that. One of them, is to create a table, called CHANGES, by example, and with the columns: TABLENAME, USERNAME, DATEANDTIME, etc. Then, for each table of your interest, you create a trigger which inserts a row in the table CHANGES when a user do an INSERT,

Re: [firebird-support] Connected databases to the Server

Doesn't work, always shows just 1 database, the current one. Sometimes with several instances, but always the same database name. Greetings. Walter. On Sun, Oct 8, 2017 at 5:25 AM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 07.10.2017