OraFAQ Forum: Forms » how to create sql statement in form6i?

Home » Developer & Programmer » Forms » how to create sql statement in form6i? (form 6i)

Mon, 05 May 2008 01:48

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

hi

How to create sql statement


      Select * from partmaster
        where partnumber like ''%'||:SearchString||'%''

please fix this problem

wbr
kanish

Mon, 05 May 2008 02:29

imran_nu
Messages: 55
Registered: February 2007
Location: Islamabad

Member


  Select * from partmaster
        where partnumber like '%' || :SearchString || '%';

Minor Mistake Cool

Previous Topic:	How to call "when-button-pressed" trigger from other control's trigger?
Next Topic:	Get the name of the application server

Goto Forum:

]

Current Time: Fri Sep 27 12:17:50 CDT 2024