Clay Shannon wrote:

><< Can you insert then 'T' or 'F' value direct using any SQL tool ???>>
>
>Yes, it works fine in DBWB
>
><<Did you put any check constraint on that domain ?>>
>
>The client uses the same charset on connect ? (I don't think this will
>be a problem but have a look)CREATE DOMAIN D_BOOLEAN AS
> CHAR(1)
> DEFAULT 'F'
> NOT NULL
> CHECK (VALUE IN ('T', 'F'))
> COLLATE NONE;
>
>Clay Shannon,
>Dimension 4 Software
>
>
>

How is declared the SP ?

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 15/03/2005