Mombu the Programming Forum sponsored links

Go Back   Mombu the Programming Forum > Programming > Record Key - GUID
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 21st May 02:47
jim mac
External User
 
Posts: 1
Default Record Key - GUID


Hi all,

I am using VB6/ ADO/ Access 2000 on a win 98 machine

I am building an order entry app and I am using a guid as a record key
my table looks like this;

tblOrders

* OrdersKey guid
OrderNo long auto number
OrderDate date

and so on

I am using the guid because I can store it and save myself some
round trips to the database should I need it further down the line.

However, I still need to provide the user with a reference number
and I may wish to use it with child tables like OrderDetails.

This app will also be used in a multi user environment.

I tried coding against a control table from which I could retrieve the next
available OrderNumber
using a max function. However, in a multi user environment I would get
trapped.
I also can not increment a control table until the order is updated.

Anyone know of a technique to manage numbering?

Any ideas greatly appreciated.


Jim
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666