Oracle Forms on iPad, Android and PCs without thick client Java Runtime Environment download. www.talkingbyte.com/?p=2
Read More TalkingByte Thinforms: Oracle Forms on iPad, Android and PCs without JREShell script to check if orcladmin account is locked, and unlock it if required # Check to see if orcladmin account is locked, and unlock it if it is. if [ “`ldapbind -p <myport> -D cn=orcladmin -w <myorcladminpassword>`” = “bind successful” ] then echo orcladmin account is ok, is not locked. else echo unlocking orcladmin […]
Read More unlock orcladmin password in shell scriptIn e.g. post-query block level trigger: IF block.check_field = ‘F’ THEN — switch on Set_Item_Property( ‘block.field’ , LOV_NAME, ‘your lov’) ; Set_Item_Property( ‘block.field’, VALIDATE_FROM_LIST, PROPERTY_TRUE); ELSE — switch off Set_Item_Property( ‘block.field’ , LOV_NAME, ”) ; Set_Item_Property( ‘block.field’, VALIDATE_FROM_LIST, PROPERTY_FALSE); END IF ; H/t François Degrelle
Read More Switch Oracle Forms List of Values on and off dynamically at run timeHowto create a popup dialog box in Oracle Forms – called ‘alerts’ although can be used for all kinds of purposes, not just alerting. First create a new alert. Alerts are listed in the forms developer object navigator, immediately underneath Triggers. You can specify text and button names in the property palette of this new […]
Read More Oracle Forms popup dialog alert boxPopup LOV boxes that retrieve their list from a database table are relatively easy to set up in oracle forms, the equivalent for a dropdown list item takes a bit more work. 1) First, create a new item in the canvas with item type as ‘List Item’ – or, in my case I changed the […]
Read More Oracle Forms Dropdown List Item values populated from database table