Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement