Simple Trigger Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm building this trigger and an error message is appearing which says: "
Error 170: Incorrect Syntax: Line 6 near "=". Could someone please help me
understand why this error is occuring? Thanks.

Create Trigger AvailableLogFootage
on tblLogs
FOR UPDATE
As
Begin
UPDATE UnDesignatedFootage = tblBundles.CurrentFootage
WHERE tblBundles.IsDesignated = 'N'
FROM tblLogs join tblBundles
On tblLogs INNER JOIN tblBundles ON tblLogs.FlitchNum = tblBundles.FlitchNum
 
Hey Mike,

Looks like you need to tell it what table to set and a SET keyword to tell
it where the fieldlist starts:

UPDATE MyTable SET UnDesignatedFootage = tblBundles.CurrentFootage
WHERE ...

HTH,

John

MrMike said:
I'm building this trigger and an error message is appearing which says: "
Error 170: Incorrect Syntax: Line 6 near "=". Could someone please help me
understand why this error is occuring? Thanks.

Create Trigger AvailableLogFootage
on tblLogs
FOR UPDATE
As
Begin
UPDATE UnDesignatedFootage = tblBundles.CurrentFootage
WHERE tblBundles.IsDesignated = 'N'
FROM tblLogs join tblBundles
On tblLogs INNER JOIN tblBundles ON tblLogs.FlitchNum =
Click to expand...
tblBundles.FlitchNum
 
That was it! Thanks John

John Spiegel said:
Hey Mike,

Looks like you need to tell it what table to set and a SET keyword to tell
it where the fieldlist starts:

UPDATE MyTable SET UnDesignatedFootage = tblBundles.CurrentFootage
WHERE ...

HTH,

John


tblBundles.FlitchNum
Click to expand...
 
Back
Top