Most recent edit on 2012-01-09 21:49:51 by ArchLineberger [corrected spelling]
Additions:
- Delete tasks - if RS operations exists, execute once for each record in Modify mode, then once again in Delete mode
Deletions:
- Delete tasks - if RS operations exist, execute once for each record in Modify mode, then once again in Delete mode
Edited on 2009-04-10 20:07:48 by ArchLineberger [Clarification to "when not executed"]
Additions:
- An undo-able programmatic update occurs within the current task
Deletions:
- An undo-able update occurs within the current task
Edited on 2007-05-08 03:49:03 by ArchLineberger
Additions:
- An undo-able update occurs within the current task
Deletions:
- An update occurs within the current task
Edited on 2007-02-03 17:44:36 by ArchLineberger
Additions:
- An update occurs within the current task
Deletions:
- An update occurs within the current task level
Edited on 2007-02-03 17:41:18 by ArchLineberger
Additions:
- An update occurs within the current task level
Deletions:
- An update occurs at the current task level
Edited on 2007-02-03 17:08:47 by ArchLineberger
Additions:
If one of the following conditions is met, the Record Suffix operations are performed then the database is updated, before the next Record Prefix or the Task Suffix.
- An update occurs at the current task level
- In a Batch task with no records in its view
Deletions:
If one of the following conditions is met, the Record Suffix operations are performed then, before the next Record Prefix or the Task Suffix, the database will be updated.
An update occurs at the task level
Batch task with no records in its view
Edited on 2007-01-04 19:57:41 by ArchLineberger
Additions:
- Delete tasks - if RS operations exist, execute once for each record in Modify mode, then once again in Delete mode
Deletions:
- Delete tasks:
if RS operations exist, execute once for each record in Modify mode, then once again in Delete mode
Edited on 2007-01-04 19:55:53 by ArchLineberger
Additions:
| STATEMENT |
UNDO pre-v10 |
Force Update v10+ |
| Virtual, update |
N |
Y |
| Real, update |
N |
Y |
| STATEMENT |
UNDO pre-v10 |
Force Update v10+ |
| Virtual, update |
N |
Y |
| Real, update |
N |
Y |
| STATEMENT |
UNDO pre-v10 |
Force Update v10+ |
| Virtual, update |
Y |
N |
| Virtual, update |
N |
Y |
| Real, update |
Y |
N |
| Real, update |
N |
Y |
| Parent virtual, varset() |
|
|
| Parent real, varset() |
|
|
Deletions:
| STATEMENT |
UNDO -v10 |
Force Update v10+ |
| Virtual, update |
N |
Y |
| Real, update |
N |
Y |
| STATEMENT |
UNDO |
| Virtual, update |
N |
| Real, update |
N |
| STATEMENT |
UNDO |
| Virtual, update |
Y |
| Virtual, update |
N |
| Real, update |
Y |
| Real, update |
N |
| Parent virtual, varset() |
|
| Parent real, varset() |
|
Edited on 2007-01-04 19:52:12 by ArchLineberger
Additions:
| STATEMENT |
UNDO -v10 |
Force Update v10+ |
| Virtual, update |
N |
Y |
| Real, update |
N |
Y |
| STATEMENT |
| Virtual, enter data |
| Real, enter data |
| Virtual, update via combo |
| Real, update via combo |
| Tab click |
Deletions:
| STATEMENT |
UNDO |
| Virtual, enter data |
|
| Real, enter data |
|
| Virtual, update via combo |
|
| Real, update via combo |
|
| Tab click |
|
Edited on 2007-01-04 19:27:58 by ArchLineberger
Additions:
If one of the following conditions is met, the Record Suffix operations are performed then, before the next Record Prefix or the Task Suffix, the database will be updated.
Deletions:
The Record Suffix operations are performed, then the database may be updated before the Task Suffix or the next Record Prefix depending on the following rules:
Edited on 2007-01-04 19:23:53 by ArchLineberger
Additions:
The Record Suffix operations are performed, then the database may be updated before the Task Suffix or the next Record Prefix depending on the following rules:
Edited on 2007-01-04 19:19:41 by ArchLineberger
Additions:
Handler
Subtask
Deletions:
Handler
Subtask
Edited on 2006-08-28 17:52:14 by ArchLineberger
Additions:
if RS operations exist, execute once for each record in Modify mode, then once again in Delete mode
Deletions:
if RS operations exist, execute once in Modify mode
execute once in Delete mode
Edited on 2006-08-28 17:47:18 by ArchLineberger
Additions:
- Task Properties / Advanced, Selection Table = Y
Record Prefix/Suffix
Deletions:
Record Prefix
Edited on 2006-08-20 22:08:30 by ArchLineberger
Additions:
- Task Control, Force Record Suffix = True
Deletions:
- Task Control, Force record Suffix = True
Edited on 2006-08-20 22:07:19 by ArchLineberger
Additions:
When is the Record Suffix executed and the database updated?
First, general rules for when is it not executed:
- An update occurs at the task level
- An update exists at any level, but is not executed due to its Cnd value
- Batch task with no records in its view
Now, when it is executed:
Batch Tasks:
- Create & Modify tasks - once for each record in the view
- Delete tasks:
if RS operations exist, execute once in Modify mode
execute once in Delete mode
Online Tasks:
- Input form updates a variable
- Task Control, Force record Suffix = True
Record Prefix
| STATEMENT |
UNDO |
| Virtual, update |
N |
| Real, update |
N |
Record Main
| STATEMENT |
UNDO |
| Virtual, enter data |
|
| Real, enter data |
|
| Virtual, update via combo |
|
| Real, update via combo |
|
| Tab click |
|
Handler
| STATEMENT |
UNDO |
| Virtual, update |
N |
| Real, update |
N |
Subtask
| STATEMENT |
UNDO |
| Virtual, update |
Y |
| Virtual, update |
N |
| Real, update |
Y |
| Real, update |
N |
| Parent virtual, varset() |
|
| Parent real, varset() |
|
Deletions:
Edited on 2006-08-20 18:22:00 by ArchLineberger
Deletions:
What causes the record Suffix to execute?
You would think this an elemetary question. Perhaps it is, but if you cannot always achieve the results you are seeking, look here. There are likely other conditions causing the engine to execute the Record Suffix. If you know of them, please add them to the list:
Batch task
• Executed so long as there is a record in the view.
Online task
• The end-user edited a field, either by an alphanumeric keystroke or
mouseclick on a tab/combobox
• An Update operation with the Undo property set to No occured in the
task or a handler.
• An Input Form operation inserted data in a variable.
• The Force Record Suffix field evaluates to True
• The task mode was changed.
• A subtask (not a handler) CONTAINS an Update operation to a parent variable.
• A subtask varset() CHANGED a variable in the parent.
Categories
CategoryHowTo
Edited on 2006-08-19 23:57:53 by ArchLineberger
Additions:
• A subtask varset() CHANGED a variable in the parent.
Deletions:
• A varset in a child task CHANGED a variable in the parent.
Edited on 2006-08-19 23:54:11 by ArchLineberger
Additions:
• A subtask (not a handler) CONTAINS an Update operation to a parent variable.
Deletions:
• A subtask (not a handler) contains an Update operation to a parent variable.
Oldest known version of this page was edited on 2006-08-19 23:52:35 by ArchLineberger []
Page view:
What causes the record Suffix to execute?
You would think this an elemetary question. Perhaps it is, but if you cannot always achieve the results you are seeking, look here. There are likely other conditions causing the engine to execute the Record Suffix. If you know of them, please add them to the list:
Batch task
• Executed so long as there is a record in the view.
Online task
• The end-user edited a field, either by an alphanumeric keystroke or
mouseclick on a tab/combobox
• An Update operation with the Undo property set to No occured in the
task or a handler.
• A subtask (not a handler) contains an Update operation to a parent variable.
• A varset in a child task CHANGED a variable in the parent.
• An Input Form operation inserted data in a variable.
• The Force Record Suffix field evaluates to True
• The task mode was changed.
Categories
CategoryHowTo
