Jiří Činčura | 20 May 08:40 2016
Picon
Gravatar

Switches for firebird.exe

Hi *,

is there some document with switches for firebird.exe? All I see is
gbak, gfix, ... RN seem to not have such section either.

--

-- 
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
_______________________________________________
Firebird-docs mailing list
Firebird-docs <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-docs
Helen Borrie | 13 May 21:34 2016
Picon
Picon

Translators: FbLangRef25 latest corrections

To translators:

I just redirected the CVS notification regarding the latest batch of
corrections in fblangref25-commons.xml and
fblangref25-functions-vars.xml.  In both cases, these are files that
are marked as already reviewed.

New builds (doc version 0.905) of both PDF and HTML are on the web
site.  The HTML was built using the new version of the stylesheet with
the sub-TOCs.

Cheers,
Helen

------------------------------------------------------------------------------
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
Helen Borrie | 13 May 12:14 2016
Picon
Picon

[Firebird-checkins] manual/src/docs/refdocs/langref/fblangref25 fblangref25-commons.xml, 1.8, 1.9 fblangref25-functions-vars.xml, 1.5, 1.6 fblangref25.xml, 1.21, 1.22

Update of /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25
In directory sfp-cvs-1.v30.ch3.sourceforge.com:/tmp/cvs-serv23534

Modified Files:
	fblangref25-commons.xml fblangref25-functions-vars.xml 
	fblangref25.xml 
Log Message:
Corrections from P. Vinkenoog and D. Simonov.

Index: fblangref25-functions-vars.xml
===================================================================
RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-functions-vars.xml,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- fblangref25-functions-vars.xml	27 Mar 2016 21:20:48 -0000	1.5
+++ fblangref25-functions-vars.xml	13 May 2016 10:14:26 -0000	1.6
 <at>  <at>  -5085,7 +5085,7  <at>  <at> 
 		  <formalpara>
 		    <title>Syntax</title>
 		    <para><blockquote>
-		        <programlisting>BIN_AND (<replaceable>number</replaceable> [,
<replaceable>number</replaceable> ...])</programlisting>
+		        <programlisting>BIN_AND (<replaceable>number</replaceable>,
<replaceable>number</replaceable> [, <replaceable>number</replaceable> ...])</programlisting>
 		      </blockquote></para>
 		  </formalpara>
       <table id="fblangref25-funcs-tbl-binand">
 <at>  <at>  -5103,15 +5103,19  <at>  <at> 
           <tbody>
(Continue reading)

Mark Rotteveel | 30 Apr 13:49 2016
Picon
Gravatar

Improve TOC and searchability of Firebird Language Reference

I've been using the Firebird Language Reference for a while now, and I 
have some annoyances with its searchability.

As an example, yesterday I was looking for a built-in function. The TOC 
unhelpfully only lists:

8. Built-in functions and Variables

     Context variables
     Scalar Functions
     Aggregate Functions

If I go to "Scalar Functions" I have:

Functions for Working with Context Variables
Mathematical Functions
Functions for Working with Strings
Date and Time Functions
Type Casting Functions
Functions for Bitwise Operations
Functions for Working with UUID
Functions for Working with Generators (Sequences)
Conditional Functions

And if I then go to "Functions for Working with Strings" I am on my own. 
At minimum I would like each of these sections to have a TOC of their 
own, so I can 1) quickly navigate to the right function and 2) easily 
link to them without having to dive into the HTML for the section id.

However compare this to the Firebird 2.5 Language Reference **Update**, 
(Continue reading)

Stefan Heymann | 27 Apr 11:01 2016
Picon

Fb3 Release Notes

Hello all,

I have seen this in the Fb3 Final Release Notes on Page 108:

  The size of the body of a stored procedure or a trigger can exceed
  the traditional limit of 32 KB. The theoretical limit provided by
  the new API is 4GB. At the moment, as a security measure, a
  hard-coded limit of 10MB is imposed. The same limit of 10MB also
  applies to any user-defined DSQL query.
  ********* It may change before the final release. *********

Regards

Stefan

------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Helen Borrie | 27 Apr 02:17 2016
Picon
Picon

FbLangRef25 Translators & Reviewers


To those currently reviewing and translating the Language Reference, I
have put up new PDF and HTML builds today - build 0.904 - and have
updated the sources in CVS - see the diff file I sent to the list.

These are small changes in the DDL and Commons chapters but they are
in sections that are marked as "already reviewed".

Cheers,
Helen

------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Helen Borrie | 27 Apr 00:38 2016
Picon
Picon

[Firebird-checkins] manual/src/docs/refdocs/langref/fblangref25 fblangref25-commons.xml, 1.7, 1.8 fblangref25-ddl.xml, 1.10, 1.11 fblangref25.xml, 1.20, 1.21

Update of /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25
In directory sfp-cvs-1.v30.ch3.sourceforge.com:/tmp/cvs-serv24351

Modified Files:
	fblangref25-commons.xml fblangref25-ddl.xml fblangref25.xml 
Log Message:
Another batch of suggested edits from Aage Johansen

Index: fblangref25-commons.xml
===================================================================
RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-commons.xml,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- fblangref25-commons.xml	28 Mar 2016 19:03:03 -0000	1.7
+++ fblangref25-commons.xml	26 Apr 2016 22:38:33 -0000	1.8
 <at>  <at>  -928,6 +928,12  <at>  <at> 
           </listitem>
         </orderedlist>
       </formalpara>
+      
+      <note>
+        <title>Note about String Comparison</title>
+        <para>When <database>CHAR</database> and <database>VARCHAR</database> fields are compared for 
+        equality, trailing spaces are ignored in all cases.</para>
+      </note>

       <section id="fblangref25-commons-othercomppreds">
         <title>Other Comparison Predicates</title>

(Continue reading)

Paul Vinkenoog | 11 Apr 05:33 2016
Picon
Gravatar

Firebird 3 Quick Start Guide

Hi all,

The Firebird 3 Quick Start Guide is available at:

  http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/Firebird-3-QuickStart.pdf
  http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/qsg3.html

It's not yet visible at the index page, because FB3 hasn't been released yet.

There are probably still some rough edges to the guide, but I couldn't wait any longer: the first packages
may be built today.

If you find any errors, please let us know.

Cheers,
Paul Vinkenoog

------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial! http://pubads.g.doubleclick.net/
gampad/clk?id=1444514301&iu=/ca-pub-7940484522588532
Helen Borrie | 10 Apr 23:39 2016
Picon
Picon

Re: LangRef 2.5beta1 - a few more suggestions /5

Hello Aage,

Monday, April 11, 2016, 6:23:52 AM, you wrote:

> I'll have mostly non-Firebird things on my mind the next week, so I'm 
> just unloading my latest comments now!

Hope it goes well for you Aage!
I'm not ignoring your suggestions, just a bit swamped at the moment
with customer work and Fb 3 release.

Thanks again!

Kia ora,
Helen

------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial! http://pubads.g.doubleclick.net/
gampad/clk?id=1444514301&iu=/ca-pub-7940484522588532
Aage Johansen | 10 Apr 20:23 2016
Picon
Picon

LangRef 2.5beta1 - a few more suggestions /5


I'll have mostly non-Firebird things on my mind the next week, so I'm 
just unloading my latest comments now!

==============================================
p.117
Add a sentence to make it clear when the trigger is fired:
For mutation events, does the trigger fire at commit or at individual 
insert/update/delete.
For two-phase-commit, it is described at p.122 (good!).

p.119:
"Declarations and embedded statements are terminated with semi-colons (;)."

For statements with a begin...end block, no semi-colon is used.
----------------------------------------

Simple "if":
   BEGIN
     IF (NEW.cust_no IS NULL) THEN
       NEW.cust_no = GEN_ID(cust_no_gen, 1);
   END

But, with a block of statements:
   BEGIN
     IF (NEW.cust_no IS NULL) THEN
     BEGIN
       NEW.cust_no = GEN_ID(cust_no_gen, 1);
     END
   END
(Continue reading)

Aage Johansen | 6 Apr 23:33 2016
Picon
Picon

LangRef 2.5beta1 - a few more suggestions /4


==============================================

p.87
Maybe a few words on the naming of "unnamed" constraints.
create table TEST (
   ID      integer  not null  primary key
)
The user might like to know that 2 constraints are created, called 
INTEG_n (f.ex. INTEG_157 (for "not null") and INTEG_158 (for "primary 
key")).  And the (unique) index will be named rdb$primaryN (f.ex. 
rdb$primary66).

----------------------------------------

p.104
Index Direction:
Explain why the user might want to have the (non-default) descending index.
Maybe that is more appropriate in an "User's Guide"?

----------------------------------------

p.107 (Active option: How is it useful?)
from:
... on the indexes of a large table in a database that is 
infrequently restored.
to:
... on the indexes of a large table in a database that is frequenty 
updated and infrequently restored.
(Maybe not really necessary?)
(Continue reading)


Gmane