DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 15 of 15

Thread: Advice or Guidance

  1. #1
    Join Date
    Sep 2004
    Location
    Northampton,United Kingdom
    Posts
    230

    Advice or Guidance

    Hi All.

    I need some advice (or guidance on what is better) for the following 2 quesctions


    1. What is the more stable way of accessing data? is it via ADO or DAO?
    2. How can I create an Array with code?

    I need to have PLUScreen(i) array so when I load a page from my PLU database I can store in the PLUScreen(i) array the Codes so on a click even of a button it would use the index number of the button to search for the product (via the PLUScreen(i) Index barcode.

    Thanks

    Andy

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    1. ADO

    2. More ways that I can count off the top of my head. What is PLUScreen?

  3. #3
    Join Date
    Sep 2004
    Location
    Northampton,United Kingdom
    Posts
    230
    PLUScreen is just a name I gave the array in the example

    I though ADO was better I mean each software I have using the DAO keeps locking you after a few hours (so I have decieded to abbandon the software and start from scrach).

    SO what methold would you recommed? it only has to match the number of keys I have on the form (25)

  4. #4
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    Is PLUScreen a control or a form? If it's a control, you can create an array by creating a single instance of the control at design time and assigning a value to its Index property. Then use the Load command at runtime to create additional instances of the control.

    If it's a form, use the New keyword to create a new instance of the form at runtime and assign the new instance to an array of type Form:

    Dim PLUScreen(1 To 25) As Form
    .
    .
    .
    nForms = nForms + 1
    Set PLUScreen(nForms) = New PLUScreen
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

  5. #5
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    Quote Originally Posted by Drew_gable
    it only has to match the number of keys I have on the form (25)
    Define "key" as you are using it.

    What are the 25 things you have on your form that you call "keys"?

  6. #6
    Join Date
    Sep 2004
    Location
    Northampton,United Kingdom
    Posts
    230
    Ok well the "key" are what the users would touch to select the item.

    they would display information or Images from the database on the key.

    the information would be pulled form the database and displayed and then in the PLUScreen index the system would store the stock id

    EXAMPLE the system would pull from the database "Country Music CD" and in the PLUScreen it would store 5018374320766 in PLUScreen(0)

    Hope that has explained it a bit more

  7. #7
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    So, this is a "Touch Screen" application?

  8. #8
    Join Date
    Sep 2004
    Location
    Northampton,United Kingdom
    Posts
    230
    Yes it is touch screen application.

    does that help?

  9. #9
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    Initially, I thought it would be a factor, but after Goggling the subject I find out that with a touchscreen, touching the button is the exact same thing as clicking on it with a mouse. It fires the click event. I never knew that (I've never worked on a touchscreen before)

    So, back to the question at hand.

    Your first post said you wanted to create the array in code. Why?

    Why not create the array in design, and write the underlaying code to go along with it at the same time.

  10. #10
    Join Date
    Sep 2004
    Location
    Northampton,United Kingdom
    Posts
    230
    I would create the array in desgin mode BUT I was thinking codeing it would be quicker.

    I am limited to what CPU Power and What Memory the Touch screen Terminals have.

    I need to support older machines with 128MB RAM and 133MHz processors as well as new machine with 1GIG RAM and 1.2GHz CPU

    So what ever I come up with HAS TO BE REALLY quick on both machines.

  11. #11
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    Two questions:

    What type of touchscreen monitor will you be rolling out?
    Do you have all CPU's, in your shop and available for testing, that your app will be required to support?

  12. #12
    Join Date
    Sep 2004
    Location
    Northampton,United Kingdom
    Posts
    230
    Touchscreen would be the Following

    Older units
    IBM 4695
    Epson IR 300

    Newer Units
    IBM SurePoS 500
    DigiPoS 1.2g

    And Yes I do have all CPU available.

  13. #13
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    Quote Originally Posted by Drew_gable
    Touchscreen would be the Following

    Older units
    IBM 4695
    Epson IR 300

    Newer Units
    IBM SurePoS 500
    DigiPoS 1.2g

    And Yes I do have all CPU available.
    Good. I'm glad to see you aren't try to fit the same screen for all PCs, and that have all PCs for testing.

    So, then, going back to your original question[Drew_gable]1. What is the more stable way of accessing data? is it via ADO or DAO?
    2. How can I create an Array with code?[/quote]I would definately say go with ADO, and create your array in design.

  14. #14
    Join Date
    Sep 2004
    Location
    Northampton,United Kingdom
    Posts
    230
    Cool Thanks for the advice guys That has helped a lot

  15. #15
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    No problem, and if you run into actual coding problems, pop back on by and start a new thread.

    Good luck!

Similar Threads

  1. Offline database update * Advice *
    By Drew_gable in forum Database
    Replies: 2
    Last Post: 05-26-2006, 04:29 PM
  2. General Advice. . .
    By spudmasher in forum ASP.NET
    Replies: 1
    Last Post: 07-29-2005, 09:33 AM
  3. Advice for breaking into the field (repost)
    By David K. in forum Careers
    Replies: 0
    Last Post: 01-15-2001, 10:21 PM
  4. advice on career
    By Prasad in forum Careers
    Replies: 9
    Last Post: 12-04-2000, 09:03 AM
  5. Advice for breaking into the field
    By David K. in forum Careers
    Replies: 0
    Last Post: 10-06-2000, 05:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center