New beta release for IBConsole available (8.1.0.266)

The main reason for publishing this release are new insights after a
discussion in the Interbase.general NG about the use of "Server Side
Database Aliases" and reviewing the documentation about it and the code
of IBConsole. There were some minor points in IBConsole that might be
confusing for the users. For the maintenance of "Server Side Database
Aliases" IbConsole needs to now the SYSDBA password. To minimize the
risk that adding, deleting or modifying a "Server Side Database
Alias"
will fail IBConsole now keeps track of the SYSDBA password and prompt
for it when it is needed and not available. To minimize the security
risk of keeping track of the SYSDBA password the settingsfile of
IBConsole is moved to the users ApplicationData.
The new beta release is available from http://www.gvsnet.nl/ibconsole.
On the revision history page there is a link to a document that
describes the implementation of aliases in IBConsole.

-- 
Gelein van de Voorde (IBConsole team)

"The blossoms on an apple tree are standardized,
and yet they are all different.
That is how we, too, should learn to build."

When entering new records in IBC, domain based DEFAULT NULL fields default 
to text value "NULL" rather than actual <null> value.

-- 
Brent Rose
brentrose@paradise.net.nz 

Brent Rose wrote:

> When entering new records in IBC, domain based DEFAULT NULL fields
> default to text value "NULL" rather than actual <null>
value.

Brent,

Can you post the Metadata of an example of a domain that has this
effect?


-- 
Gelein van de Voorde (IBConsole team)

"The blossoms on an apple tree are standardized,
and yet they are all different.
That is how we, too, should learn to build."

Hi Gelein

The syntax taken from "View Metadata" in ibc (ie the full db metadata)
is 
like this:

CREATE DOMAIN "DOM_FIRSTNAME" AS VARCHAR(20) DEFAULT NULL COLLATE
DB_US437;

Interestingly, the syntax taken from the "Metadata" tab of the domain

definition reads:

CREATE DOMAIN "DOM_FIRSTNAME" AS VARCHAR(20) CHARACTER SET DOS437 
DEFAULT 
'NULL' COLLATE DB_US437;

ie the default NULL value is enclosed in single quotes, which would explain 
the result I observe. I re-checked the original script I used to declare the 
domains, and it did not include any quotes at all - in fact it was:

CREATE DOMAIN DOM_FIRSTNAME AS VARCHAR(20) CHARACTER SET DOS437 DEFAULT NULL 
COLLATE DB_US437;

-- 
Brent Rose
Whats On Report
brent@whatson.co.nz


"Gelein van de Voorde" <gelein@gvsnet.nl> wrote in message 
news:47bb38e7$1@newsgroups.borland.com...
> Brent Rose wrote:
>
>> When entering new records in IBC, domain based DEFAULT NULL fields
>> default to text value "NULL" rather than actual <null>
value.
>
> Brent,
>
> Can you post the Metadata of an example of a domain that has this
> effect?
>
>
> -- 
> Gelein van de Voorde (IBConsole team)
>
> "The blossoms on an apple tree are standardized,
> and yet they are all different.
> That is how we, too, should learn to build."
>
> Alvar Alto