Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Pro VB Databases
Password Reminder
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Pro VB Databases Advanced-level VB coding questions specific to using VB with databases. Beginning-level questions or issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old November 26th, 2003, 03:13 AM
Registered User
Join Date: Nov 2003
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Recommended cursor type

Hi all,
I am now developing an VB6 application accesing a SQL Server 2000 database. The customer would like to have several input forms to select and browse the data. He wants to have several comboboxes with all client names, item names, provider names and so on, and choose data from those comos. Each table has about 700-1000 records. So that means that combos should have this number of items. What kind of cursor is the more suitable for this kind of application?

Thank you in advance.

Reply With Quote
  #2 (permalink)  
Old November 26th, 2003, 12:01 PM
Friend of Wrox
Join Date: Jun 2003
Location: Sparks, NV, USA.
Posts: 101
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jlick

First, I would like to say that you may want to consult with your client. Dropdown lists that have 700-1000 items are very difficult to use. I would suggest a listbox instead, so that the user can see multiple items at once, and it will be easier to scroll.

I am assuming that you are not using data binding. (If you are I cannot offer advise, as I NEVER use them.) That being said, I would use:

CursorLocation = adUseClient
CursorType = adOpenStatic

You should also consider how often the data changes, and how often you want to reload the data. You may find that if the data doesn't change often cacheing the data will help performance.

Your client and you should determine what this means, and what the implications are.

John R Lick
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Recommended book forJ2Me? chobo2 Java Basics 1 July 29th, 2008 08:17 PM
Magnetic Cursor - Target Area Cursor? gcarcass .NET Framework 2.0 1 May 5th, 2008 07:20 AM
Recommended books before reading this one? AmericanXer0 BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 1 September 23rd, 2007 06:32 PM
Updating Recordsets with LockType and Cursor Type arimakidd Classic ASP Databases 7 August 1st, 2005 09:23 PM
Change Cursor Type When Using the Command Object hcweb Classic ASP Basics 2 April 7th, 2004 01:08 PM

All times are GMT -4. The time now is 05:44 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.