Triggers

Hi

Q1. I have a small problem, actually I am looking for something we use in SQL server
Inserted.CustName or Deleted.CustNam

Q2. I have a table A. I have some triggers in this to update table
I am flocking table A before updation. Do I need to flock table B in the trigger ?
If I flock table B in the trigger, will the locking and unlocking will happen fo
every record ? because my updation is 'update where <condition>' for more that on
record. Will it execute the trigger and lock table B for all the record
separatly ? That is if the update condition is for 10 records, it will update
record in A and execute the trigger then update the 2nd record and execute th
trigger etc

Mike

Wolfgang
Thu Mar 04 13:00:41 CST 2004

Hello Mike!

Q2: You need to SET MULTILOCKS ON
And the trigger in table B will fire for every record which is added or
updated. What you should not do is to change any value of table A while a
trigger is executed, because the would fire the same trigger again and
update the value and fire the trigger and update the value and fire the
trigger.........

--
_________________

MFG
Wolfgang Schmale

MS Visual FoxPro MVP

--------------------------------
"Mike" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag
news:09382B07-F045-48FD-B9AE-1C15D89B62EB@microsoft.com...
> Hi,
>
> Q1. I have a small problem, actually I am looking for something we use in
SQL server,
> Inserted.CustName or Deleted.CustName
>
> Q2. I have a table A. I have some triggers in this to update table B
> I am flocking table A before updation. Do I need to flock table B in
the trigger ?
> If I flock table B in the trigger, will the locking and unlocking will
happen for
> every record ? because my updation is 'update where <condition>' for
more that one
> record. Will it execute the trigger and lock table B for all the
records
> separatly ? That is if the update condition is for 10 records, it
will update 1
> record in A and execute the trigger then update the 2nd record and
execute the
> trigger etc.
>
> Mike