[Openroad-users] Character Data and Toggle Fields

[Kim Ginnerup]

Hi Martin,
 
I'm pretty sure you cannot do it that way.
But I think you can do the transformation from char values to int using a select case.
 
Kim

________________________________

Fra: openroad-users-bounces at peerlessit.com på vegne af Bloomfield, Martin (PSD)
Sendt: to 1/25/2007 17:17
Til: Openroad-Users
Emne: 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 <mailto:martin.bloomfield at psd.defra.gsi.gov.uk>  
Website: www.pesticides.gov.uk <http://www.pesticides.gov.uk/>