Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Designer: Unbound items (Read 5123 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Designer: Unbound items
24.04.09 at 10:41:22
 
Designer: Unbound items
 
I want to use an unbound item in a block to display derived values.  
 
First I designed the module using the bound items.
 
Next I added an unbound item with the following properties
Unbound type=SQL Expression, Insert=No, Update=No, Query=No, Display=Yes, Display Type=Text, Datatype=CHAR
 
To test the unbound item I added as SQL:
Derivation Expression=upper('hello world')
 
Now the unbound item always derives hello world as value for each row. This now can serve as a base to do the real implementation where e.g. a PL/SQL call can be used as SQL expression to derive a value.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Calling PL/SQL to populate an unbound item
Reply #1 - 24.04.09 at 10:57:44
 
Calling PL/SQL to populate an unbound item
 
Using bound items as input for a function in the SQL expression you can refer to the items using their names, not prefixing the item names using a colon.
 
Example:
mypack.myfunction(myblockitem,otherblock.otheritem)
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Designer: Unbound items
Reply #2 - 07.05.09 at 10:52:40
 
Calling client PL/SQL
 
To be able to call local PL/SQL in the form you need to set the property "Unbound Type" of the unbound item to "Client Side Function"
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1