| Table Handlers [message #174129] |
Fri, 26 May 2006 01:32  |
prash_says
Messages: 5
Registered: May 2006
Location: India
|
Junior Member |
|
|
Hi,
I am developing a form. I have created a package with PROCEDURE insert_row, PROCEDURE lock_row, PROCEDURE update_row.In the same manner i have created 3 different packages, so that i can u as for 3 table's.
Can any one guide me how do use thihs packages in the Form, how do i call this package so that it can be used as table handler.
Would be appreciated if you can give me with some example...
Thanks in advance
|
|
|
|
| Re: Table Handlers [message #174165 is a reply to message #174129] |
Fri, 26 May 2006 05:32  |
sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata
|
Senior Member |
|
|
Now you can make a block on Procedure .here is an example you can see it.
run pkg.txt to generate the package and then run the attached form.
steps involved in this are
1. create the package.
2.create a manual block.
3. change QUERY DATA SOURCE TYPE as PROCEDURE
4. change QUERY DATA SOURCE NAME as cv_datasource.empquery (name of procedure).
5. change QUERY DATA SOURCE Column (check the sample form for ex.)
6. change QUERY DATA SOURCE ARGUMENT (check the sample form for ex.)
Thanka & Regards
Sanka
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
