daogu

please correct me if i am wrong

cust_po_number is a varchar column….so i am trying to

build the where clause here…..i know for sure that

one single quote should be replaced by three if we want

to include a varchar colunmn..so is the above condition

valid one?

---

Answer:try this

---

Answer:Why not simply

---

Answer:Dear Littlefoot,

I Think your code will not work as CUST_PO_NUMBER is a varchar datatype

---

Answer:Huh, right … I didn’t read the question carefully enough. I apologize.

Here’s how it is to be done: in order to check whether you’ve done it correctly or not, create a display item which will be used to show variable value (check the attached FMB file, based on Scott’s schema), or display it using the MESSAGE built-in.

Shortly:

Related posts:

1. How to connect multiple schemas at a time in Form Builder Could anybody tell me the Steps or Procedure to...
2. Horizontal Toolbar Hi All Freinds I want display horizontal Toolbar at...
3. How to convert date twice without using extra variables Hi I have an LOV in my form START...
4. Need to check space in varchar2 columns Hi , I need to check whether a varchar2...
5. Very Basic User Form Hello I am very beginer of the Oracle Form...