Re: Forms3 Delete a char of the field data
Date: 13 Aug 92 14:47:39 GMT
Message-ID: <1992Aug13.150523.31_at_bmwf1f.bmwf.gv.at>
In article <1992Aug12.162132.278_at_falcon.navsses.navy.mil>, huynh_at_falcon.navsses.navy.mil writes:
> Greetings,
>
> I am using sqlforms version 3.0.
> I have a problem which I don't even know where to start. I want to delete a
> char of the enter data into a field.
> eg. Let 's say I have a field that requires data
> HULL: _________; where the users will enter something like HULL: LST-1183,
> I want to delete the "-" sign/char.
> I want the data to be in the form of 'LST1183', but because of the way our data
> bases are set up, the users will enter the HULL in the form of 'LST-1183'. I
> want to delete the "-" sign/char, and also at the time somehow join the
> LST 1183 together so that it is like the user had just entered 'LST1183' and
> not 'LST-1183'.
> I need to convert 'LST-1183' into 'LST1183', so that it corresponds with the
> database HULL to do the query.
>
> I hope I have made myself clear. Anyone who is interested, but didn't quite
> undertand me, please feel free to ask. I will be more than happy to make
> myself clear.
>
> Any comments or suggestions will be appreciated. Thanks in advance.
Create a POST-CHANGE trigger on the field HULL:
IF :hull != REPLACE(REPLACE(:hull,'-',''),' ','') THEN
:hull := REPLACE(REPLACE(:hull,'-',''),' ',''); END IF;
-- ================================================================================ ^ Federal Ministry of Science and Research B | M <-------------------------------------------------------------------------+----> Computer Center W | F | Klaus-Michael Hatzinger mail: hatzinger_m_at_bmwf1f.bmwf.gv.at | Bangkasse 1/209 phone: 0043-222-53120/5188 | 1014 Vienna, Austria fax: 0043-222-53120/5155 V ================================================================================Received on Thu Aug 13 1992 - 16:47:39 CEST