[firebird-support] Re: Is there an easy way for input rows from a script file?

---In firebird-support@yahoogroups.com, wrote : Hello everybody If I connect to a database "Database1" using ISQL, I can write something like: OUTPUT MyFile.DAT; SELECT * FROM MyTable; OUTPUT; And all the rows of "MyTable" will go to the text file

Re: [firebird-support] Is there an easy way for input rows from a script file?

Thank you, Sean Greetings. Walter. On Wed, Feb 15, 2017 at 6:43 PM, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > > > Walter, > > > If I connect to a database "Database1" using ISQL, I can write something > like: > > > > OUTPUT

Re: [firebird-support] Is there an easy way for input rows from a script file?

Thank you very much Set, I will try your advice. Off topic: can you say me what the letters HTH means? Greetings. Walter. On Wed, Feb 15, 2017 at 6:31 PM, setysvar setys...@gmail.com [firebird-support] wrote: > > > Den 15.02.2017 17:07, skrev 'Walter R.

RE: [firebird-support] Is there an easy way for input rows from a script file?

Walter, > If I connect to a database "Database1" using ISQL, I can write something like: > > OUTPUT MyFile.DAT; > SELECT * FROM MyTable; > OUTPUT; > > And all the rows of "MyTable" will go to the text file "MyFile.DAT". That's ok > and works fine. > > But now, I want to connect to "Database2",

[firebird-support] Is there an easy way for input rows from a script file?

Hello everybody If I connect to a database "Database1" using ISQL, I can write something like: OUTPUT MyFile.DAT; SELECT * FROM MyTable; OUTPUT; And all the rows of "MyTable" will go to the text file "MyFile.DAT". That's ok and works fine. But now, I want to connect to "Database2", which also

RE: [firebird-support] FIREBIRD PIVOT function or Matrix

Thanks Mark Agreed the PIVOT feature is wonderful. However I am stuck with the customer using Firebird(no complaints). But I still need a solution as to how go ahead? Please any suggestions or guidance, seeing as you have done this already? Stef van der Merwe From:

Re: [firebird-support] FIREBIRD PIVOT function or Matrix

On 14-2-2017 15:48, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 14.02.2017 14:15, 'Stef' s...@autotech.co.za [firebird-support] wrote: >> Any suggestions on my DB design and query to display the values in matrix >> (pivot) format? > >Simple client-side code can show you

RE: [firebird-support] FIREBIRD PIVOT function or Matrix

Thanks all But this still does not answer my question as to db design and query? Regards Stef van der Merwe From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 14 February 2017 06:03 PM To: 'Leyne, Sean' s...@broadviewsoftware.com

Re: [firebird-support] FIREBIRD PIVOT function or Matrix

I go with Sean. Btw, this is already in the tracker: http://tracker.firebirdsql.org/browse/CORE-1738 Vote on it! Carlos www.firebirdnews.org - www.FireBase.com.br >> > Any suggestions on my DB design and query to display the values in matrix >> (pivot) format? >> >>Simple client-side