ASE Trigger
select @command = 'INSERT INTO tablename SELECT * FROM inserted'
execute(@command)
Hi all, i am building a dynamic SQL Command inside a trigger, i received an error message that table inserted is not found. (i am using ASE 12.5.1)
thanks,
Software/Hardware used:
Software/Hardware used:
ASKED:
August 15, 2005 9:46 AM
UPDATED:
August 16, 2005 4:55 AM
Answer Wiki:
I don't know much about ASE, but from what I know about programming for the web in general and sql, I think you need to declare that inserted is a variable, and if it isn't, then rather than calling for all the records from inserted, you need to call the records from the table.
I do know that inserted isn't a valid SQL query, and therefore your sql server is picking it up as the table name and is reporting the error that it cannot find the table inserted
hope this helps
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
