Article ID: 945133 - Last Review: August 2, 2011 - Revision: 2.0

Error message when you use custom VBA code and you call the sqlfetch API function in Microsoft Dynamics SL: "System Message 10232 - Assertion failure!"

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
Expand all | Collapse all

SYMPTOMS

After you add a sqlfetch API function call by using Customization Manager in Microsoft Dynamics SL, you may receive the following error message:

System Message 10232 - Assertion failure!
File: sqlms2.cpp
Line: 465
Expression: precbuff AND viewlen > 0 AND (Bind Timestamps EQ FALSE OR BindTimestamps EQ TRUE)

CAUSE

The .Dh file is not imported. This problem occurs after you add a sqlfetch API function call in the VBA code by using Customization Manager

RESOLUTION

To resolve the problem, import the appropriate .Dh file for the specific sqlfetch API function call. To do this, follow these steps:
  1. Open the Visual Basic Editor.
  2. Right-click Module, and then click Import File.
  3. In the Import File dialog box, browse to the .Dh files.

    Note The default location for the .Dh files in Microsoft Dynamics SL 7.0 and later versions is Microsoft Dynamics\SL\Applications\DB\DHfiles. The default location for the .Dh files in Microsoft Dynamics SL 6.5 and earlier versions is Solomon\DB\DHfiles.
  4. In the Files of type box, select All Files (*.*).
  5. Select the appropriate .Dh file.

MORE INFORMATION

The Swimapi.Dll file (kernel) retrieves records from the Microsoft Dynamics SL database and saves a copy of the record in the memory. The storage space in memory is a globally declared variable of a user-defined data type (UDT). The storage space is also known as "the buffer". A file that has a .Dh extension, contains the UDT. Each table in the Microsoft Dynamics SL database has a corresponding .Dh file. If the compiled screen in Microsoft Dynamics SL does not specify the .Dh file, you must import the .Dh file in the Visual Basic Editor so that you can later query the table.

APPLIES TO
  • Microsoft Dynamics SL 2011
  • Microsoft Dynamics SL 7.0
  • Microsoft Dynamics SL 6.5, when used with:
    • Tools for Visual Basic
    • Customization Manager
Keywords: 
kbexpertiseadvanced kbtshoot kbprb kbmbsmigrate kbexpertiseinter KB945133