makesecret

The makesecret statement makes the current database disappear, while leaving it open in memory.


Parameters

No parameters.


Description

The makesecret statement makes the current database disappear. All of the windows for this database will be closed. However, the database is still in memory, so the database can still be used for lookups, etc.

The procedure below makes the Price List database disappear, but remain open.

window "Price List"
makesecret

Even though the Price List database is now invisible, you can still access information in the database.

myPrice=lookup("Price List",Description,Item,Price,0,0)

To modify information in a hidden database you must temporarily create a secret window. This can be done with the window statement. This example adjusts the quantity of an item in an invisible inventory file.

local wasWindow
wasWindow=info("windowname")
window "Inventory:Secret"
find Description=fieldvalue("Invoice",InvoiceItem)
OnHandQty=OnHandQty-fieldvalue("Invoice",InvoiceQt
window wasWindow

Note: A simpler method to do this is to use the Post or PostAdjust statements:


See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.