At 03:15 PM 16/12/2010, rockyoh73505 wrote:

>First trouble I have is that I am trying to save the data by
>" insert into test value('ID1', 'Young');

SQL> insert into test values ('ID1', 'Young'); /* NOTE, it is values, not value */
SQL> COMMIT; /* !!!!!!!!!!!!!! */

>and when I exute this command it shows but when I quit and write
>"sql> select * from test" all I see is
>"sql> " that is it, it seems as though the data has disappeared..

You have to ***commit*** data changes in Firebird. The reason you can see the changes is that you are in *your* transaction and can see the changes *you* made during that transaction. If you don't commit, but then do
SQL> quit;
then transaction is rolled back and the database is unchanged.

>It will be super helpful if I could get the help on changing the data from remote computer as well... ^^;;

Remote computer needs the Firebird client installed (along with a few other things). Make sure it is fbclient.dll that is actually loaded and not a stray interbase client in your system directory.

Make sure you know the host name of the computer that is running Firebird server and that has the database.

From the remote computer, the connection string syntax is
hostname:d:\databases\mydatabase.fdb

Read the Quick Start guide! it is all in there.

>and second question is that I am trying to use the GUI instead of the shell in window 7 enviroment.
>I have rapidsql as well as IBConsole..... But I cannnot achieve connection between firebird and these programs but my 2 computer using firebird get the connection.... Is there some kind of thing I have to it or is it better for me to use other programs???

RapidSQL should work - provided you use the correct connection syntax.
IBConsole - forget it. It is a fairly dumb tool for InterBase, not Firebird. It works with the InterBase client gds32.dll. (You can generate fbclient.dll as gds32.dll using an option in the installer but the ibconsole program itself is not Firebird-aware).

There *are* better tools, many of them free. FlameRobin (www.flamerobin.org) is the easiest to use for a newbie. Fairly full list at http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_admin_tools

./hb