[Openroad-users] Character Data and Toggle Fields

[Neil.Warnock at luminary.co.uk]

A questionable approach would be to use the decode SQL function to convert the n, y, N, Y etc into 1, 0 etc as you select the data.

 

Neil Warnock
Luminary Solutions
Tel: +44 (0)870 757 40 90  
Mob: +44 (0)771 265 0291  
Email: Neil.Warnock at luminary.co.uk

For more information on Luminary go to http://www.luminary.co.uk
Luminary Solutions Limited Registered in England No 4854134 VAT Reg No. 829 3166 13
Registered Office: 16/17 Pavilion Business Park, Royds Hall Road, Leeds LS12 6AJ

 


> _____________________________________________ 
> 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: ATT73473.txt >> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://peerlessit.com/pipermail/openroad-users/attachments/20070125/d124a1fc/attachment.html