Home » Developer & Programmer » Forms » Trim issue (Form Builder 6i, Window Xp)
icon4.gif  Trim issue [message #519566] Sun, 14 August 2011 22:15 Go to next message
fadhzone
Messages: 61
Registered: April 2008
Member
Hi All,
SELECT  COUNT(*) INTO V_CNT_EXIST
FROM    GOODS_RECEIVED_HDR H, PO P
WHERE   H.STORE_CD    = P.STORE_CD
AND     H.SLIP_NO     = P.PO_SLIPNO
AND     H.STORE_CD    = :BL_HDR.STORE_CD
AND     H.SUP_MAINCD  = :BL_HDR.SUP_MAINCD
AND     P.SUP_SUBCD   = :BL_HDR.SUP_SUBCD
AND     P.SUP_LOCCD   = :BL_HDR.SUP_LOCCD
AND	H.STATUS     IN ('O','R','V')
AND    TRIM(H.INVOICE_NO) = TRIM(:BL_HDR.INVOICE_NO);


The purpose of the code is to find the duplicate data before save. I want to trim the invoice no but there is error :
Error 201 - identifier must be declared. But when I change to RTRIM or LTRIM, it run well.
Is it TRIM function cannot be used in form builder?
Thanks.
Re: Trim issue [message #519581 is a reply to message #519566] Mon, 15 August 2011 01:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68667
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not in your version.
Use LTRIM(RTRIM(...))

Regards
Michel
Re: Trim issue [message #519633 is a reply to message #519581] Mon, 15 August 2011 19:26 Go to previous messageGo to next message
fadhzone
Messages: 61
Registered: April 2008
Member
Thanks Mr Cadot..

I already tried with that method. But finally I used Replace function.
Re: Trim issue [message #519642 is a reply to message #519633] Tue, 16 August 2011 01:08 Go to previous message
Michel Cadot
Messages: 68667
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
REPLACE is not the same thing than TRIM.
How do you use REPLACE to make it working as TRIM (or maybe you have never a space inside your values)?

Regards
Michel
Previous Topic: Oracle Web
Next Topic: Problem with WEBUTIL_C_API
Goto Forum:
  


Current Time: Fri Jul 26 07:36:49 CDT 2024