Chuck, On Aug 16, 2008, at 3:12 AM, Chuck Hill wrote:
As I said earlier, much fun here!
Actually, the fun begins sooner I've supposed. Probably I just have my dumb day today or should go to catch a Z or two, or should just learn SQL thoroughly :), but I can't create a simplest trigger in FrontBase : ( Can someone please point me out to my mistake?
Based on some examples I've found at the Web and the FB documentation, I would think a simple trigger which would just unconditionally set the order number should look e.g. like this (OID is the ORDER's PK):
CREATE TRIGGER "TEST" AFTER INSERT ON "ORDER" REFERENCING NEW ROW AS "X" BEGIN UPDATE "ORDER" SET "ORDERNUMBER"=1 WHERE "OID"="X"."OID"; END
Oops though: Error code 527. Semantic error 485. The database was launched with "additional options" -triggers=yes. Thanks, --- Ondra Čada OCSoftware: [EMAIL PROTECTED] http://www.ocs.cz private [EMAIL PROTECTED] http://www.ocs.cz/oc _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
