Flame Robin: Difference between revisions

From eStream Software
 
(11 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]
* [http://www.estream.com.my/downloadfile/Fairy/FlameRobin.zip Alternative Download]
* [https://download.sql.com.my/customer/Fairy/FlameRobin.zip Alternative Download]
* MD5 : 52F515BAA34F2A1DFA986AAFF7D9DB3E (Alternative Link Only)
* MD5 : 52F515BAA34F2A1DFA986AAFF7D9DB3E (Alternative Link Only)


Line 43: Line 46:
| Hostname || Server Name/IP Address
| Hostname || Server Name/IP Address
|-
|-
| Port Number || Firebird Port number (default is 3050)
| Port Number || Firebird Port number (Default is '''3050''')
|}
|}
:04. Click '''Save''' button
:04. Click '''Save''' button
Line 50: Line 53:


===Register Database===
===Register Database===
* Can add more then 1 database if you wanted to but if can just register only 1 to & you can just keep reuse the same setting
* 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====
====Register New Database====
:01. Click ''Database | Register existing database...''
:01. Click ''Database | Register existing database...''
Line 65: Line 68:
| Authentication || Use only ''Use saved user name and password''  
| Authentication || Use only ''Use saved user name and password''  
|-
|-
| User name || Firebird default user name (SYSDBA)
| User name || Firebird user name (Default is '''SYSDBA''')
|-
|-
| Password || Firebird default password (masterkey)
| Password || Firebird password (Default is '''masterkey''')
|-
|-
| Charset || Use only ''NONE''
| Charset || Set to '''UTF8''' (For FB3.0 & above)
|-
|-
| Role || Leave it empty
| Role || Leave it empty
Line 88: Line 91:


<div style="float: right;">  [[#top|[top]]]</div>
<div style="float: right;">  [[#top|[top]]]</div>
===Write Query===
===Write Query===
[[File:FlameRobin-06.jpg|center]]
[[File:FlameRobin-06.jpg|center]]
:01. Select here
:01. Select here
[[File:FlameRobin-07.jpg|center]]
:02. Click ''Database | Run a query...''
:02. Click ''Database | Run a query...''
[[File:FlameRobin-07.jpg|center]]
[[File:FlameRobin-08.jpg|center]]
:03. You can enter/type your SQL Query here
:04. Press '''F4''' to Execute 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 02:49, 5 July 2022

Introduction

Is an External Firebird Console Application.


Template.Warning-01.jpg
Using this Application is at your own risk.
Estream will not responsible on any data corrupt or missing due to usage of this application.

Requirement

  • Firebird Server

Program

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
FlameRobin-01.jpg
01. Right Click Here
FlameRobin-02.jpg
02. Select Server registration info...
FlameRobin-03.jpg
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...
FlameRobin-04.jpg
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

FlameRobin-05.jpg
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

FlameRobin-06.jpg
01. Select here
FlameRobin-07.jpg
02. Click Database | Run a query...
FlameRobin-08.jpg
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