Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Triggers in a form
Message
From
05/01/2001 00:51:16
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Triggers in a form
Miscellaneous
Thread ID:
00459678
Message ID:
00459678
Views:
50
Hi everybody!

Is there a way to send information to a Editbox when a trigger fires up?
I have a form with a editbox and I want know when an specific field (balance) is equal to 0. I tried with a trigger update and stored procedure but I can't figure out how to put this information into the editbox.

Here's my code:

Create trigger on inventory for Update as IsBalanceZero()

Procedure IsBalanceZero

if _triggerlevel = 1
if inventory.balance = 0 then
wait window "Equal to 0"
* here I'd like to send this info to the editbox
* thisform.Edit1.value = Inventory.Item_ID + "Re-order"
endif
return .t.
endif
EndProc

thanks in advance
Happy New Year!!!

Martin Alcaraz
Next
Reply
Map
View

Click here to load this message in the networking platform