The problem is - in our system - we give the users the ability to set the Sequence #'s - such as when they want to roll it back for some reason. Also, we let them change it so that they can initially start at a higher number. But, in the end - they need to be to set it to a specific value at any point in time. Which I suspect leaves out the usage of AutoInc.
-K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sytze de Boer Sent: Wednesday, February 03, 2010 2:31 PM To: [email protected] Subject: Re: Sequence Control # Problem! You can set it to START with a specific number. S On Thu, Feb 4, 2010 at 8:22 AM, Kurt Wendt <[email protected]> wrote: > Thanks for your input Sytze! > > I hadn't thought about the AutoInc type field. But, I was wondering - > with that type of field - can you set it to a specific value? I don't > think I have actually used this type of field before - or definitely not > for a long time. > > -K- > > -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Sytze de Boer > Sent: Wednesday, February 03, 2010 1:47 PM > > I have had identical problems to what you describe. > My scenario was a little different where there were some 15-20 users > creating invoices and/or purchase orders and/or general ledger > entries. > All required a unique id number > > I overcame the problem by using a table with an AUTOINC field > I haven't encountered this problem since. > > > > On Thu, Feb 4, 2010 at 5:46 AM, Dave Crozier <[email protected]> > wrote: >> Kurt, >> Also take a look at: >> > http://fox.wikis.com/wc.dll?Wiki~IsWindowsReallyMadeForVFP-styledDataMan > ipul >> ation? >> >> Or >> http://tinyurl.com/yd8zdm6 >> >> Dave C > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a14071a1...@us-ny-mail-002.waitex.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
