[Openroad-users] Character Data and Toggle Fields

[Bloomfield, Martin (PSD)]

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





Department for Environment, Food and Rural Affairs (Defra)

This email and any attachments is intended for the named recipient only.
If you have received it in error you have no authority to use, disclose,
store or copy any of its contents and you should destroy it and inform
the sender.
Whilst this email and associated attachments will have been checked
for known viruses whilst within Defra systems we can accept no
responsibility once it has left our systems.
Communications on Defra's computer systems may be monitored and/or
recorded to secure the effective operation of the system and for other
lawful purposes.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 2749 bytes
Desc: not available
Url : http://peerlessit.com/pipermail/openroad-users/attachments/20070125/a94915fe/attachment.bin