Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Network:
Windows 2000 Server
>Ed,
>
>I think it's very hard to achieve what you're trying to achieve and probably not worth the effort. Your Order number should be a unique key and user should not even see it. If the later is the case, then it doesn't matter if some numbers are skipped.
The Order number should not be the primary key. It should be visible to the users, just as an invoice number should be visible to the users. The primary key/foreign key should not be visible to the user.
>
>>Dear All,
>>
>>I have made a program with a multiple station input say an ‘order’ which will have a unique order number automatically produced by the program once any user choose ‘new’ order. My problem is how could I be able to control this as any user may also opt to cancel or not to continue to process the order input. I want to avoid any order number which were not completed in the table or any order number skipped.
>>
>>Your advise would be greatly appreciated.
>>
>>Thanks.
>>
>>Ed
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement