Home -> Usenet -> comp.databases.oracle -> [Q] Field formatting. How do you split one field to four.

[Q] Field formatting. How do you split one field to four.

From: <msoppitt_at_eastman.co.uk>
Date: 1996/08/07
Message-ID: <839418024.24575.0_at_eastman.demon.co.uk>#1/1 







Forms 4.5


I have four fields, value 99 each and go to make one database field of
ie 01||03 ||01||05 each set of two figures represent a description
from an Lov (ie 4 diferent lovs make a discription that = A,B,C,D).
How do i read the 8 numeric field from the database (ie on query) and
split it into the four fields.


I tried using a hidden box over the four 99 fields which would display
for query mode and hide for insert but this is a bit messy.



Any suggestions would be more than appreciated.
Thanks, Michael
Received on Wed Aug 07 1996 - 00:00:00 CEST












Original text of this message