Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert Triggers and Views
Message
From
29/10/1998 20:25:47
 
 
To
28/10/1998 12:37:01
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00151695
Message ID:
00152573
Views:
23
>Thanks, Bob. But I think I'm going abandon this experiment in mid-hatch! I'll have to mull it over a bit more.
>
>...snip
>>How about adding a call to a function from the rule off all the fields.
>...snip



Hi all!
Beware when will trigger fire!

Insert Trigger: Insert-SQL, Append Blank, Recall Record
Update Trigger: Update Some field, Update all fields after Append Blank
Delete Trigger: Delete Record

If you use Append blank in your application, handle Update Trigger and check
All the OldVar() to know is it a Fresh Add Record or update old record!
else you need to take care Recall Record or Blank record problem for Insert-SQL!

For your reference, go to file section and download WorkLog V1.10 to see... ^-^;

p.s. Remind you that you need to pay more attention on trigger coding.
if any error occurs, you can't make change on table! (All Reverted!!)
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Previous
Reply
Map
View

Click here to load this message in the networking platform