PRB: Default Values Not Shown in Input Parameters Dialog Box (156141)
The information in this article applies to:
- Microsoft Visual C++ 4.2
- Microsoft Visual C++, 32-bit Enterprise Edition 5.0
- Microsoft Visual C++, 32-bit Enterprise Edition 6.0
- Microsoft Visual C++, 32-bit Professional Edition 5.0
- Microsoft Visual C++, 32-bit Professional Edition 6.0
- Microsoft Visual C++, 32-bit Learning Edition 6.0
This article was previously published under Q156141 SYMPTOMS
When you execute or debug any stored procedure with default value
parameters, the Execute Stored Procedure dialog box does not show the default values.
CAUSE
Open Database Connectivity (ODBC) and SQL Server do not provide any means to retrieve the default values for a stored procedure.
RESOLUTION
The default values are correctly passed to the stored procedure when you do
not enter explicit values inside the Execute Stored Procedure dialog box.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. We are researching this problem
and will post new information here in the Microsoft Knowledge Base as it
becomes available.
| Modification Type: | Major | Last Reviewed: | 12/1/2003 |
|---|
| Keywords: | kbBug kbDatabase kbDebug kbEEdition kbprb kbProgramming kbSQLProg KB156141 |
|---|
|