[Openroad-users] Character Data and Toggle Fields

[Richard M. Wright]

Just a quick thought! Could you make 'y' and 'n' global constants?

> _____________________________________________ 
> From: 	openroad-users-bounces at peerlessit.com
> [mailto:openroad-users-bounces at peerlessit.com]  On Behalf Of
> Bloomfield, Martin (PSD)
> Sent:	25 January 2007 16:17
> To:	Openroad-Users
> Subject:	Character Data and Toggle Fields
> 
> OpenROAD experts,
> 
> I suspect that what I'm trying to do is not possible, but seem to
> remember having done it before.  I have imported a data file into
> Ingres which contains several single character validation columns.
> These have values of '' or 'n', or 'y' or 'n'.  I am wanting to
> display this data on a form using a toggle field, such that if the
> value is blank, then the toggle is clear, but if it is 'n' the toggle
> is checked.
> 
> Reading the documentation for toggle fields suggest it has a data type
> of integer, however, when I set it to varchar(1) I get no errors, but
> the toggles do not work.
> 
> Has anyone ever done this, or do I have to write code to map between
> the 0 and 1 values of the toggle field and the '' and 'n' of my data
> object?
> 
> We are running OpenROAD 4.1 (sp2) on Windows XP.
> 
> Thanks,
> 
> Martin Bloomfield.
> ____________________________________________
> Application Developer & Database Administrator
> IT Branch,
> Pesticides Safety Directorate
> YORK
> 
> Email: martin.bloomfield at psd.defra.gsi.gov.uk
> Website: www.pesticides.gov.uk
> 
> 
> 
> 
>  << File: ATT3476282.txt >> 

************************************************************************
This Internet E-mail is intended solely for the person to whom it is addressed. It may contain confidential or privileged information. If you have received it in error please notify us immediately by telephone and destroy the transmission. You must not copy, distribute or take any action in reliance on it.

Aerosystems International               Phone: +44 (0)1935 443000
                                        Fax  : +44 (0)1935 443111
                                        Web  : www.aeroint.com
************************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://peerlessit.com/pipermail/openroad-users/attachments/20070125/c5ec515e/attachment.html