Click here to Skip to main content
15,914,222 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralVisual Basic 6 Help in DLL Pin
afrodit13-Jul-04 20:49
afrodit13-Jul-04 20:49 
GeneralRe: Visual Basic 6 Help in DLL Pin
Ravi S.V.14-Jul-04 0:21
Ravi S.V.14-Jul-04 0:21 
GeneralInterface Question Pin
beowulfagate13-Jul-04 20:27
beowulfagate13-Jul-04 20:27 
GeneralRe: Interface Question Pin
Dave Kreskowiak14-Jul-04 2:46
mveDave Kreskowiak14-Jul-04 2:46 
Generalauto generating number Pin
GaryKoh13-Jul-04 19:47
GaryKoh13-Jul-04 19:47 
GeneralRe: auto generating number Pin
Dave Kreskowiak14-Jul-04 2:36
mveDave Kreskowiak14-Jul-04 2:36 
GeneralRe: auto generating number Pin
GaryKoh14-Jul-04 19:59
GaryKoh14-Jul-04 19:59 
GeneralRe: auto generating number Pin
Dave Kreskowiak16-Jul-04 0:57
mveDave Kreskowiak16-Jul-04 0:57 
There is no one article that will do what you want. Your requirements are a combination of a bunch of smaller techniques that need to be put together correctly.

What's with the "random" order number? I've never seen a requirement where the order number must be random. I've only seen "serial number" type order numbers.

How I've seen it done in the past, and I've done this myself, is to have a seperate table in the database that holds your databases status and statistics, such as the last used order number. Your code would call a stored procedure in the database that retrieves the last used order number, increments it, stores it back in the table and creates a blank order record in the "orders" table, using the newly created order number. Then this record is sent back to your program as a dataset (SELECT statement). Your app then fills in the details of the order and writes back the order record, without having to worry about the order number at all.


RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

GeneralUpload Pin
Verolix13-Jul-04 15:18
Verolix13-Jul-04 15:18 
GeneralRe: Upload Pin
Dave Kreskowiak13-Jul-04 16:12
mveDave Kreskowiak13-Jul-04 16:12 
GeneralCE VB.Net Owner Drawn ListBox Pin
Chris Reiff13-Jul-04 14:23
Chris Reiff13-Jul-04 14:23 
GeneralRe: CE VB.Net Owner Drawn ListBox Pin
Dave Kreskowiak13-Jul-04 16:15
mveDave Kreskowiak13-Jul-04 16:15 
GeneralA complicated string... Pin
Brad Fackrell13-Jul-04 10:11
Brad Fackrell13-Jul-04 10:11 
GeneralRe: A complicated string... Pin
Dave Kreskowiak13-Jul-04 12:19
mveDave Kreskowiak13-Jul-04 12:19 
GeneralRe: A complicated string... Pin
Brad Fackrell13-Jul-04 12:42
Brad Fackrell13-Jul-04 12:42 
Generalvb code Pin
nazerudeen13-Jul-04 5:56
nazerudeen13-Jul-04 5:56 
GeneralRe: vb code Pin
Dave Kreskowiak13-Jul-04 12:13
mveDave Kreskowiak13-Jul-04 12:13 
GeneralRe: vb code Pin
jonathan1515-Jul-04 5:29
jonathan1515-Jul-04 5:29 
QuestionHow to connect Microsoft Access Report in vb.net Pin
Member 122179713-Jul-04 2:58
Member 122179713-Jul-04 2:58 
AnswerRe: How to connect Microsoft Access Report in vb.net Pin
martyconnelly14-Jul-04 15:31
martyconnelly14-Jul-04 15:31 
GeneralIntegrating Outlook Pin
Het210912-Jul-04 23:32
Het210912-Jul-04 23:32 
GeneralSave as WebPages using WebBrowser control Pin
Member 122179712-Jul-04 21:43
Member 122179712-Jul-04 21:43 
GeneralRe: Save as WebPages using WebBrowser control Pin
monkeyjoe14-Jul-04 14:43
monkeyjoe14-Jul-04 14:43 
QuestionHow to find which windows API(.dll) is getting called Pin
Member 122179712-Jul-04 21:40
Member 122179712-Jul-04 21:40 
AnswerRe: How to find which windows API(.dll) is getting called Pin
Dave Kreskowiak13-Jul-04 0:56
mveDave Kreskowiak13-Jul-04 0:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.