| (7 intermediate revisions by the same user not shown) | |||
| Line 13: | Line 13: | ||
---------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- | ||
|} | |} | ||
==Requirement== | |||
* Firebird Server | |||
==Program== | ==Program== | ||
* [http://www.flamerobin.org/ Flame Robin Homepage] | * [http://www.flamerobin.org/ Flame Robin Homepage] | ||
* [ | * [https://download.sql.com.my/customer/Fairy/FlameRobin(x64).zip Alternative Download] | ||
* MD5 : | * MD5 : DCF5938386D92FE858803923CD171841 (Alternative Link Only) | ||
==Installation== | ==Installation== | ||
| Line 43: | Line 46: | ||
| Hostname || Server Name/IP Address | | Hostname || Server Name/IP Address | ||
|- | |- | ||
| Port Number || Firebird Port number ( | | Port Number || Firebird Port number (Default is '''3050''') | ||
|} | |} | ||
:04. Click '''Save''' button | :04. Click '''Save''' button | ||
| Line 69: | Line 72: | ||
| Password || Firebird password (Default is '''masterkey''') | | Password || Firebird password (Default is '''masterkey''') | ||
|- | |- | ||
| Charset || | | Charset || Set to '''UTF8''' (For FB3.0 & above) | ||
|- | |- | ||
| Role || Leave it empty | | Role || Leave it empty | ||
| Line 99: | Line 102: | ||
:05. Press '''F5''' to Commit your Query | :05. Press '''F5''' to Commit your Query | ||
<div style="float: right;"> [[#top|[top]]]</div> | <div style="float: right;"> [[#top|[top]]]</div> | ||
==See also== | |||
* Others [[Customisation]] | |||
Latest revision as of 07:54, 27 November 2024
Introduction
Is an External Firebird Console Application.
|
Requirement
- Firebird Server
Program
- Flame Robin Homepage
- Alternative Download
- MD5 : DCF5938386D92FE858803923CD171841 (Alternative Link Only)
Installation
Using Official download
- Just Double Click the Setup & Follow the Setup wizard.
Using Alternative Download
- Just Unzip/Extract the file to the location you wanted.
Steps
Server Information
- Only 1 time setting for each Firebird Version
- 01. Right Click Here
- 02. Select Server registration info...
- 03. Enter as following
| Field | Description |
|---|---|
| Display name | Can be anything (eg Happy) |
| Hostname | Server Name/IP Address |
| Port Number | Firebird Port number (Default is 3050) |
- 04. Click Save button
Register Database
- Can add more then 1 database if you wanted to but if can just register only 1 & you can just keep reuse the same setting
Register New Database
- 01. Click Database | Register existing database...
- 02. Enter as following
| Field | Description |
|---|---|
| Display name | Can be anything (eg ACC-0038) |
| Database path | The Firebird FDB file path |
| Authentication | Use only Use saved user name and password |
| User name | Firebird user name (Default is SYSDBA) |
| Password | Firebird password (Default is masterkey) |
| Charset | Set to UTF8 (For FB3.0 & above) |
| Role | Leave it empty |
- 03. Click Save button
- 04. Click Database | Connect
Update/Reuse Registered Database
- 01. Select here
- 02. Click Database | Database Registration Info...
- 03. You will see same as Steps 02 Register New Database at above
- 04. Just change the Display name (optional) & Database path
- 05. Click Save button
- 06. Click Database | Connect
Write Query
- 01. Select here
- 02. Click Database | Run a query...
- 03. You can enter/type your SQL Query here
- 04. Press F4 to Execute your Query
- 05. Press F5 to Commit your Query
See also
- Others Customisation