Re: [Flamerobin-devel] DDL output of string literals uses double quotes.

[Lester C. <le...@ls...>]

Roger Vellacott wrote:
> First, I want to say how much I appreciate Flamerobin.  It has taken a
> long time to wean me off IB_SQL, but it's finally happening. If we could
> only have a built-in datapump, and the ability to edit text blobs, I
> would never use anything else.

I'm with you on that one ...
Switching to Linux for the servers has made IB_SQL less attractive and I'm 
slowly moving every site to Flamerobin, but those are the two bits that mean 
IB_SQL is still on one of the Windows boxes.

> I have a problem though.
> 
> It seems that when I ask for the DDL of an object, some string literals
> are given double quotes, rather than single quotes.  It is then not
> possible to use the DDL output as part of a script.
> 
> For example, I create a domain as follows:
> 
> CREATE DOMAIN BOOLEAN
> AS Char(1)
> DEFAULT 'F';
> 
> But if I ask for the DDL of the domain it returns
> 
> CREATE DOMAIN "BOOLEAN"
> AS Char(1)
> DEFAULT "F"

That is one that has been flagged before. The "F" is obviously wrong, and 
double quoting comes up a few times where it may not be appropriate. The other 
little niggle is the 'Char' which magically changes from the CHAR format that 
*I* prefer ;)

-- 
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Firebird - http://www.firebirdsql.org/index.php