[firebird-support] Connecting with ODBC driver

I am using a Firebird 2.5.8 64 bit server with the ODBC 2.0.5 64 bit driver. I do get the connection from MS Excel and I get a list of tables, but I don't see the fields in the tables and thus not the data. Using Qlik Sense Desktop I have the same problem, however there I am able to open the

Re: [firebird-support] Show Columns

That...is an unbelievably helpful page and that query should be made part of the official docs! Daniel On 3/23/2018 9:18 AM, edmende...@gmail.com [firebird-support] wrote: Daniel, Not sure if this answers your question but I’ve had situations where I needed a way to get column details and

Re: [firebird-support] select *at least* N rows

Yes, but remember about good join condition then and if needed sort condition especially you can use system table e.g. RDB$RELATION_FIELDS (it contain many records also in empty database) and JOIN on RDB$RELATION_NAME=’RDB$DATABASE’ AND RDB$FIELD_ID=0 instead of “G.OUT_NO=1” regards, Karol

Re: [firebird-support] select *at least* N rows

That's a very interesting solution as well Karol! Thanks! I've just realized that I can "left join" my table against *any* table which I know it already has enough records for my purpose

Re: [firebird-support] select *at least* N rows

Hi, i know that you got the answer but, maybe this trick is interesting for you because it is simplest for use in any query but require creation of one simple procedure. I use it always in situation like you with fixed numbers of rows with nulls

RE: [firebird-support] select *at least* N rows

Thank you very much Mark and András!!! I've tried András solution... I replaced (mechanically, without undestanding too much what was going on...) and it did the trick perfectly! Now is time to study a bit more and try to understand András answer :) Thanks a million again!!!

RE: [firebird-support] select *at least* N rows

r by is not necessary, but leaving it out makes you rely on an implementation detail. If you do add it, the "nulls last" is required. Mark -- Mark Rotteveel __ Information from ESET Mail Security, version of virus signature database 17106 (20180323) __ The message was

Re: [firebird-support] select *at least* N rows

On 23-3-2018 18:26, shg_siste...@yahoo.com.ar [firebird-support] wrote: > Hello! is there any trick to select a fixed number of rows? I mean, no > matter if I have 2 rows which match the select, I need to always return > 10 rows. Of course the last 8 would be all null in this example... > > I

[firebird-support] select *at least* N rows

Hello! is there any trick to select a fixed number of rows? I mean, no matter if I have 2 rows which match the select, I need to always return 10 rows. Of course the last 8 would be all null in this example... I hope I'm clear with my question! Not sure if I'm in the "right path", but if I

RE: [firebird-support] Show Columns

Daniel, Not sure if this answers your question but I've had situations where I needed a way to get column details and table ddl within our application. We ended up creating a stored procedure that would return that information. The following linked helped me with understanding what needed

[firebird-support] Fwd: SourceForge Project of the Month Vote

Přeposlaná zpráva Předmět: SourceForge Project of the Month Vote Datum: Fri, 23 Mar 2018 13:30:24 +0800 Od: Joan Uy Ang Hi, If you’re receiving this email it is because one of your projects is up for Project of the Month for May 2018. The