By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,364 Members | 1,518 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,364 IT Pros & Developers. It's quick & easy.

Simple Trigger Question

P: n/a
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
Jul 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" <Mr****@discussions.microsoft.com> wrote in message
news:2D**********************************@microsof t.com...
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
Jul 21 '05 #2

P: n/a
That was it! Thanks John

"John Spiegel" wrote:
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" <Mr****@discussions.microsoft.com> wrote in message
news:2D**********************************@microsof t.com...
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

Jul 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.