How To Use the VB 6.0 DataEnvironment with Parameterized Queries (193866)
The information in this article applies to:
- Microsoft Visual Basic Professional Edition for Windows 6.0
- Microsoft Visual Basic Enterprise Edition for Windows 6.0
This article was previously published under Q193866 SUMMARY
The Visual Basic 6.0 DataEnvironment simplifies the process of building
parameterized queries. However, using these queries with bound controls may
not behave the way you would expect. This article is designed to explain
how these queries interact with the bound controls and to help ensure that
you can utilize these queries in your application.
NOTE: This article assumes that you are working with a SQL Server database.
The DataEnvironment makes a number of OLE DB API calls at design-time in
order to retrieve data about the parameters in your query. Not all OLE DB
providers or ODBC drivers return information about the name, data type and
direction for the query's parameters. As a result, using parameterized
queries with the DataEnvironment is not supported for all drivers and
providers. This functionality is supported for the SQL Server and Oracle
OLE DB providers and ODBC drivers that are included with Microsoft Visual
Basic 6.0.
Modification Type: | Minor | Last Reviewed: | 7/13/2004 |
---|
Keywords: | kbhowto KB193866 |
---|
|