Re: [firebird-support] CLI to firebird

2018-08-01 Thread 'River~~' river14ap...@gmail.com [firebird-support]
Thanks Kjell. My preference is to type SQL in a CLI environment. It's good to know of the free form SQL in FR but it's still not as fast (for me) as doing it in a console / terminal. To "just open a query window" still looks to me like a superfluous step. But each to their own preference. R~~

Re: [firebird-support] CLI to firebird

2018-08-01 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
Den 2018-08-01 kl. 10:44, skrev Mark Rotteveel m...@lawinegevaar.nl [firebird-support]: > > On 2018-08-01 09:14, Kjell Rilbe kjell.ri...@marknadsinformation.se > [firebird-support] wrote: > > The benefits, as I see it, are the object trees, command history, data > > grid, CSV export, log output

Re: [firebird-support] CLI to firebird

2018-08-01 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2018-08-01 09:14, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > The benefits, as I see it, are the object trees, command history, data > grid, CSV export, log output with stats, syntax highlighting, etc. That > said, I wish they would bring FlameRobin up to fully

Re: [firebird-support] CLI to firebird

2018-08-01 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
Den 2018-07-31 kl. 10:44, skrev trueriver river14ap...@gmail.com [firebird-support]: > I am used to creating tables and users and even databases by typing > SQL into a command line client. > > Forgive me if I am missing some clue in the documention but there I > have not found anything about

Re: [firebird-support] CLI to firebird

2018-07-31 Thread 'River~~' river14ap...@gmail.com [firebird-support]
Thanks Mark, Yes and I now I see it and don't know how I missed it before... Regards R~~ On Tue, 31 Jul 2018, 20:53 Mark Rotteveel m...@lawinegevaar.nl [firebird-support], wrote: > > > On 31-7-2018 10:44, trueriver river14ap...@gmail.com [firebird-support] > wrote: > > So my question is > > >

Re: [firebird-support] CLI to firebird

2018-07-31 Thread Lee Nash leen...@barbers.co.uk [firebird-support]
Hi Mark, Thank you that’s exactly what I did!! I created a new user named the exact same as the user that created the role and o got access to the data.. Thank you for taking the time to answer! Sent from my iPhone On 31 Jul 2018, at 20:53, Mark Rotteveel

Re: [firebird-support] CLI to firebird

2018-07-31 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 31-7-2018 10:44, trueriver river14ap...@gmail.com [firebird-support] wrote: > So my question is > > a: is there a CLI client I have overlooked in the docs? Yes there is: isql (although some distributions rename it, eg isql-fb on Ubuntu). See also

[firebird-support] CLI to firebird

2018-07-31 Thread trueriver river14ap...@gmail.com [firebird-support]
I am used to creating tables and users and even databases by typing SQL into a command line client. Forgive me if I am missing some clue in the documention but there I have not found anything about how to do that for firebird 3.0 FlameRobin composes create table SQL for you and you fill in the