Results 1 to 19 of 19

Thread: Check for new record in Network app

Threaded View

  1. #18
    VB-aholic & Lovin' It LaVolpe's Avatar
    Join Date
    Oct 2007
    Location
    Beside Waldo
    Posts
    19,541

    Re: Check for new record in Network app

    I guess our ideas are not sinking in, because the potential solution I and koolsid posted can guarantee that. Either our ideas are not sinking in or both of us are way off base regarding understanding the situation.

    If the following scenario creates a problem, then the posted non-timer solution by koolsid and myself may not work as is
    1. You have 3 pcs up and running, each wrote blank records to the db & each are waiting for customers
    :: Pc1 shows nr 101, Pc2 shows nr 102, Pc3 shows nr 103
    2. A customer comes to pc #2 and will get customer number 102. Record is added to db & now pc2 shows nr 104
    3. A customer comes to pc #3 and will get customer number 103. Record is added to db & now pc3 shows nr 105
    4. Customer finally comes to pc #1 after 10 more customers have visited pc #2 & #3. This customer will get nr 101 and the pc will now show #115 after updating the db.

    Does it really matter which customer ID is used at any one time, as long as no number is duplicated?
    Last edited by LaVolpe; Mar 1st, 2009 at 03:58 PM.
    Insomnia is just a byproduct of, "It can't be done"

    Classics Enthusiast? Here's my 1969 Mustang Mach I Fastback. Her sister '67 Coupe has been adopted

    Newbie? Novice? Bored? Spend a few minutes browsing the FAQ section of the forum.
    Read the HitchHiker's Guide to Getting Help on the Forums.
    Here is the list of TAGs you can use to format your posts
    Here are VB6 Help Files online


    {Alpha Image Control} {Memory Leak FAQ} {Unicode Open/Save Dialog} {Resource Image Viewer/Extractor}
    {VB and DPI Tutorial} {Manifest Creator} {UserControl Button Template} {stdPicture Render Usage}

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width