[Openroad-users] Character Data and Toggle Fields

[Kenneth.H.Olsson at tietoenator.com]

Hear, Hear!
 
How about the color of
o RadioField indicators
o OptionField indicator 
o ScrollBars in general
o Trace Window
 
How about shading,
o LightShade
o Shade
o DarkShade
Should not shading depend on both bg and fg?
 
Regards
Kenneth Olsson
 
TietoEnator Corporation
Phone +46   8 632 15 09
Mobile +46 70 365 46 38 
Kenneth.H.Olsson at TietoEnator.com <mailto:Kenneth.H.Olsson at TietoEnator.com> 



________________________________

	From: openroad-users-bounces at peerlessit.com [mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Andrew
	Sent: den 29 januari 2007 00:40
	To: International OpenROAD Users
	Subject: Re: [Openroad-users] Character Data and Toggle Fields
	
	
	Support for background colours would also be nice.
	
	Hi Simon.
	
	
	Simon Lovell wrote: 

		A nice way of doing it!  The old fashioned way was to use LOCATE('NY', col1) - 1
		
		When inserting/updating you can use CHAREXTRACT('NY', :tgl 1) if you want to do it in one statement.
		
		Of course, support for character toggles is what I would prefer.  It would require an "OnValue" & "OffValue" attributes for ToggleField
		
		And if OpenROAD had the conditional expression (C's ?: operator) we mightn't be having this conversation either.
		
		-----Original Message-----
		From: "Kim Ginnerup" [kgi at bording.dk]
		Date: 26/01/2007 06:33 AM
		
		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  
		Website: www.pesticides.gov.uk  
		
		  

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://peerlessit.com/pipermail/openroad-users/attachments/20070129/bb7be31b/attachment.html