• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: sequential numbering across more instances
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: sequential numbering across more instances


  • Subject: Re: sequential numbering across more instances
  • From: Ondřej Čada <email@hidden>
  • Date: Fri, 15 Aug 2008 21:16:30 +0200

Chuck,

On Aug 15, 2008, at 9:00 PM, Chuck Hill wrote:

It's probably easier to wrap the same idea inside some simple direct SQL statements.

If you are willing to be DB specific, an After Insert trigger might be the best way to handle this. Just make sure the order number attribute is not used for locking.

Ha... this looks like I can save some fun\b\b\b time!

The server is FrontBase and the possibility the client would ever switch is completely negligible (at least one advantage here ;))

Low-level SQL is not exactly my cup of tea (to be frank I haven't even know what triggers are!). Am reading on them in the docs the very now and it looks pretty promising.

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


  • Follow-Ups:
    • Re: sequential numbering across more instances
      • From: Chuck Hill <email@hidden>
References: 
 >sequential numbering across more instances (From: Ondřej Čada <email@hidden>)
 >Re: sequential numbering across more instances (From: Florijan Stamenkovic <email@hidden>)
 >Re: sequential numbering across more instances (From: Ondřej Čada <email@hidden>)
 >Re: sequential numbering across more instances (From: Chuck Hill <email@hidden>)
 >Re: sequential numbering across more instances (From: Guido Neitzer <email@hidden>)
 >Re: sequential numbering across more instances (From: Chuck Hill <email@hidden>)

  • Prev by Date: Re: sequential numbering across more instances
  • Next by Date: Re: sequential numbering across more instances
  • Previous by thread: Re: sequential numbering across more instances
  • Next by thread: Re: sequential numbering across more instances
  • Index(es):
    • Date
    • Thread