Article List for VB 3.0: General Database Programming

The information in this article applies to:

• FastTips for Microsoft Visual Basic for Windows, version 3.0

INSTRUCTION

Microsoft FastTips is available 24 hours a day, 7 days a week, from a touch-tone telephone. To order items from this catalog, first select the items you want to receive, noting the five- to six-digit number of the Item ID shown below for each item, and then:

- Dial the toll-free FastTips number (800) 936-4300. - When prompted, select Microsoft Visual Basic. - Press one (1) on your phone keypad to select Express Order Service. - When prompted, select the delivery method, fax. - When prompted, enter your three-digit area code and seven-digit fax

  number on your phone keypad.

  to five items.

ARTICLE LISTING

ITEM ID  ARTICLE TITLE                                               PAGES

Q 71067  How to Set Tab Stops in a Visual Basic List Box                 5
Q 104339 PRB: TableDefs Not Updated When SQL Statement Creates Table     1
Q 105539 How to Use VB Control Property or Variable in SQL Statement     2
Q 105540 PRB: Error or GP Fault When Pass Data Control as Control        1
Q 105766 PRB: Invalid Property Value When Binding Masked Edit Control    4

Q 106270 PRB: Illegal to Use Find Method with Table Object Variable      2
Q 106492 How to Call SQL Stored Procedures from Visual Basic             2

Q 106494 PRB: No Current Record Error In VB When Database is Empty       3
Q 106535 How VB Can Determine If Table Is Locked By Other Processes      2

Q 107074 How to Change Read-Only Access of a Data Control at Run Time    3
Q 107362 BUG: Name Not Found in This Collection When Deleting Member     2
Q 107363 BUG: Incorrect VB Error When Delete Index on Open Table         3
Q 107748 How to Create a Parameter Query in Visual Basic for Windows     3

Q 108145 VISDATA Example of Every Data Access Function in VB Prof 3.0    3
Q 108146 How to Create a Microsoft Access Database using VB Prof 3.0     2
Q 108147 How to Copy Table from One Database to Another in VB Prof 3.0   3
Q 108148 How to Delete a Field from a Populated Table                    7
Q 108149 Comparison of Seek Versus Find Methods, for VB Data Access      3

Q 108150 How to Count Rows Affected Before Query in VB Prof ver 3.0      1
Q 108235 DOC: Revised Index Property (Data Access)                       2
Q 108379 LONG: Overview of Data Access in Visual Basic Version 3.0       6

Q 108423 How to Attach an External Database Table to a VB 3.0 Database   3

Q 108467 How to Request Exclusive Use of a Table in VB Prof 3.0          2

Q 109219 How to List the Fields in a Table & the Tables in a Database    4

Q 109995 PRB: Dynaset Loses Contents After Transaction Rollback          2
Q 110497 How to Use Seek and MoveNext to Find a Group/Range of Records   2
Q 110588 How to Copy a Record from One Table to Another in VB            1
Q 110618 PRB: Object Variable Not Set When Referencing Data Control      1
Q 110722 PRB: Commit or Rollback without BeginTrans Error and VB Forms   3

Q 110723 Documentation and Features for Visual Basic's Data Manager      2
Q 110732 PRB: Error: Couldn't Lock File SHARE.EXE Hasn't Been Loaded     1
Q 110752 How to Use SQL SELECT Statement Without Field Syntax Error      2
Q 110753 Create Database with Data Manager & View w/ Text/Data Control   2
Q 110959 How to Delete a Table from a Database Using Visual Basic        2

Q 111286 PRB: Novell Btrieve Unexpected Error from External DB Driver    1
Q 111304 PRB: VB Record Too Large When Add or Update Record > 2K         3
Q 113335 How to Create Nested Queries in Visual Basic 3.0 Prof Edition   5
Q 113437 BUG: SQL Server GetDate() Function Error: Record is deleted     3
Q 113701 How to Access Multiple Databases in an SQL Query                4

Q 113949 PRB: GetChunk & AppendChunk Not Allowed on Non-Memo Fields      2
Q 113953 How to Use the Three Levels of Database Locking in VB 3.0       7
Q 114592 How to Construct a Self-Join Query in Visual Basic 3.0          2
Q 115237 How to Use Temporary Tables in SQL Server from Visual Basic     7
Q 115712 How to Fill a List Box from a Snapshot Generically              3

Q 115986 How to Avoid Common Database Programming Mistakes in VB         2
Q 120073 How to Rotate a Pen Windows Application                         6

Q 130646 PRB: DAO References Not Enabled When Porting an Older VB App    1
Q 137025 FAQ: Most Frequently Asked Questions About VB 3.0 SQL Queries   5