Flame Robin: Difference between revisions

From eStream Software
 
(26 intermediate revisions by the same user not shown)
Line 1: Line 1:
==Introduction==
==Introduction==
Is an External Firebird Console Application.
Is an External Firebird Console Application.
{| style="margin: 1em auto 1em auto;"
|-
|
----------------------------------------------------------------------------------------------------------------------------------------------------
{|
|-
| [[File:Template.Warning-01.jpg|80px]]||
: 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==
==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 15: Line 30:


==Steps==
==Steps==
===Server Information===
* Only 1 time setting for each Firebird Version
[[File:FlameRobin-01.jpg|center]]
:01. Right Click Here
[[File:FlameRobin-02.jpg|center]]
:02. Select ''Server registration info...''
[[File:FlameRobin-03.jpg|center]]
:03. Enter as following
{| class="wikitable" style="margin: 1em auto 1em auto;"
|-
! 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
<div style="float: right;">  [[#top|[top]]]</div>
===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...''
[[File:FlameRobin-04.jpg|center]]
:02. Enter as following
{| class="wikitable" style="margin: 1em auto 1em auto;"
|-
! 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''
<div style="float: right;">  [[#top|[top]]]</div>
====Update/Reuse Registered Database====
[[File:FlameRobin-05.jpg|center]]
: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''
<div style="float: right;">  [[#top|[top]]]</div>
===Write Query===
[[File:FlameRobin-06.jpg|center]]
:01. Select here
[[File:FlameRobin-07.jpg|center]]
:02. Click ''Database | Run a query...''
[[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>
==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