PRB: Default Values Not Shown in Input Parameters Dialog Box

ID: Q156141

The information in this article applies to:

Microsoft Visual C++ 32-bit Edition, versions 4.2, 5.0, 6.0

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.

WORKAROUND

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.

Additional query words:

Keywords : kbprg kbDebug kbEEdition kbMFC kbSQL kbVC kbVC420 kbVC500 kbVC600
Version : :4.2,5.0,6.0
Platform : NT WINDOWS
Issue type : kbprb