I'm trying to create a trigger in a REALSQLdatabase database and
having trouble. The error is 'near "SET": syntax error'. What am I
missing?
triggerStatement = "CREATE TRIGGER " + tableName + "_onInsert
BEFORE INSERT ON " + tableName _
+ " FOR EACH ROW BEGIN " _
+ " SET NEW.created = now();" _
+ " END"
db.SQLExecute(triggerStatement)
Brad Weber
FlatTop Technology, Inc.
---
Custom Software Solutions
http://www.FlatTopInc.com
Ph. 303.635.8055
Fax 303.635.1845
_______________________________________________
Unsubscribe:
<[EMAIL PROTECTED]>
REAL Software has decided to consolidate this mailing list with the online Forums.
On Monday, February 12, 2007, this mailing list will no longer be active. We
encourage you to continue your REALbasic and REAL SQL Server discussions on the
Forums. If you are not presently a member of the forum, please sign up today at
<http://forums.realsoftware.com>.
