Subject | Re: [firebird-support] Connect to Sample FDB |
---|---|
Author | Helen Borrie |
Post date | 2006-04-13T23:52:17Z |
At 07:46 AM 14/04/2006, you wrote:
fonts, size, etc.)? If not, let me know and I'll try to walk you
through it off-line. ISQL and the other command-line tools follow
any custom settings in the shell. As I think I mentioned yesterday,
I have a shortcut that opens a shell directly in Firebird's \bin
directory. It opens in "full-screen" mode which, for my convenience,
is half a monitor wide; my background colour is dark green and my
text is Lucida Console in white. So, if your reader does better with
some background/font/font colour settings than others, this may be
your rescue! Perhaps something like a bolded Lucida console in black
on white might even make it possible for you to see things like SQL>
and CON> yourself, if the reader ignores them.
work-in-progress in the firebird-docs project. There is "Using
Firebird" on the IBPhoenix subscription CD, which is for Firebird
1.0. The firebird-docs group is revamping the sources from that book
totally and upgrading it to Firebird 1.5 and 2.0.
forget to terminate every statement with a semicolon, or else the
CON> prompt will just sit there waiting for the CON[TINUATION].
and including InterBase 6.0 (more or less).
There is also a big HTML document that contains the [not entirely
up-to-date] syntaxes with links from the summaries and indexes. It
used to be available at
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_60_sqlref but
right now it seems to be broken. However, this one works:
http://www.channelcrm.dk/DownloadFiles/SQLRef.html
After that, you need the language sections (DML and DDL) of the
v.1.5.3 release notes.
Rick, if possible, could you remember to delete the old message text
when you top-post to replies? Thanks.
./heLen
>Hi All:Did you know that you can customise the command shell (colours,
>I use a screen reader as I'm visually impaired. It does not work so well
>with the isql shell.
fonts, size, etc.)? If not, let me know and I'll try to walk you
through it off-line. ISQL and the other command-line tools follow
any custom settings in the shell. As I think I mentioned yesterday,
I have a shortcut that opens a shell directly in Firebird's \bin
directory. It opens in "full-screen" mode which, for my convenience,
is half a monitor wide; my background colour is dark green and my
text is Lucida Console in white. So, if your reader does better with
some background/font/font colour settings than others, this may be
your rescue! Perhaps something like a bolded Lucida console in black
on white might even make it possible for you to see things like SQL>
and CON> yourself, if the reader ignores them.
>I have managed to connect to the example employee.fdbThere isn't really an up-to-date "Firebird Users Manual" yet - it's
>database I think as when everything is entered correctly I hear nothing,
>that is no error message.
>Next I wanted to execute a command against the dB to see if I'm actually
>connected so went looking for the FireBird Users Manual in the docs but I
>guess they are on a cd I might have to order.
work-in-progress in the firebird-docs project. There is "Using
Firebird" on the IBPhoenix subscription CD, which is for Firebird
1.0. The firebird-docs group is revamping the sources from that book
totally and upgrading it to Firebird 1.5 and 2.0.
> Is there anyplace that tellsDo you have OpGuide.pdf, the Borland IB 6 beta book?
>about using isql which I haven't been able to find yet?
>Or, is there someplace I can find out what a script isYes: The Firebird Book.
>and how to write one so I can
>avoid using isql shell?
>My last option is to jump right into using Liberty Basic with ODBC to tryCan't comment as I don't know what Liberty Basic is/does.
>and test the connection.
>Can I enter a standard sql statement against the database in isql likeYes, that's what isql is for (amongst other things). Just don't
>select something from something?
forget to terminate every statement with a semicolon, or else the
CON> prompt will just sit there waiting for the CON[TINUATION].
>I'll have to look up syntax for sql statements if this will work.The free book for that is LangRef.pdf, which covers the syntax up to
and including InterBase 6.0 (more or less).
There is also a big HTML document that contains the [not entirely
up-to-date] syntaxes with links from the summaries and indexes. It
used to be available at
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_60_sqlref but
right now it seems to be broken. However, this one works:
http://www.channelcrm.dk/DownloadFiles/SQLRef.html
After that, you need the language sections (DML and DDL) of the
v.1.5.3 release notes.
Rick, if possible, could you remember to delete the old message text
when you top-post to replies? Thanks.
./heLen