Re: sequential numbering across more instances
Re: sequential numbering across more instances
- Subject: Re: sequential numbering across more instances
- From: Ondřej Čada <email@hidden>
- Date: Sat, 16 Aug 2008 03:52:54 +0200
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@hidden http://www.ocs.cz
private email@hidden http://www.ocs.cz/oc
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden