Home » Developer & Programmer » Forms » Help Needed for Freight Calculation (10g XE)
|
|
|
|
|
|
|
|
 Re: Help Needed for Freight Calculation [message #681834 is a reply to message #681829] |
Thu, 03 September 2020 01:22  |
 |
M HANIF
Messages: 20
Registered: April 2019
|
Junior Member |
|
|
Littlefoot wrote on Wed, 02 September 2020 15:18Quote:the problem is that the field where I use formula cannot enter value into database
Why not? Is that field based on a table column (and the block based on the table)? If so, it *should* work simply by committing changes you've made.
Otherwise, it depends on what the form actually does, what it is based on, and what processing you do. Perhaps you'll have to store that value manually (e.g. by creating a PRE-INSERT trigger, or write an ON-INSERT trigger), or call a procedure which will do that for you, or ...
Dear Brother,
Block is also a database block, based on table, field is also database item and column name is also based on table column name....
But on any database item, when calculation mode is changed to formula and formula is inserted....it does not store values into database table....
I'm confused.....
If I create a function then,
from where it will be called?
Or the trigger Pre-Insert/ Post-Insert.....will it be a block level trigger?
|
|
|
|
Goto Forum:
Current Time: Sat May 03 23:54:14 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
