MOD2000: Incorrect Case with xp_modWFDrop and xp_modWFShutdown

ID: Q238769

The information in this article applies to:

Microsoft Office 2000 Developer

Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

In the Microsoft Access Workflow Designer Developer's Guide Help system, xp_modWfDrop is described as an extended stored procedure that discards information for workflow tables cached by the workflow engine, and xp_modWfShutdown is described as an extended stored procedure that stops the workflow engine.

These extended stored procedures are referenced in the following topics:

modWfDrop (in the "Stored Procedures Reference" section).

modWfShutdown (in the "Stored Procedures Reference" section).

Stored Procedures (in the "References" section).

RESOLUTION

These extended stored procedures are actually named xp_modWFDrop and xp_modWFShutdown. In Microsoft SQL Server, the names of extended stored procedures are case-sensitive even if you have the sort order set to case-insensitive.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

To see the proper extended stored procedure names:

Open the Microsoft SQL Server Query Analyzer. Connect to the proper Microsoft SQL Server that houses the workflow-enabled solution database.

Type Execute sp_helpextendedproc, and then press F5. Scroll through the results-set list. Note that xp_modWFDrop and xp_modWFShutdown are in the list (with an uppercase F), but that xp_modWfDrop and xp_modWfShutdown (with a lowercase f) are not in the list.

Additional query words: pra doc bug docerr documentation error wrong

Keywords : kbdocerr kbdta modWFDesigner
Version : :
Platform : WINDOWS
Issue type : kbbug