BUG: ESQL for C Precompiler /BIND Option Builds on SELECT
PSS ID Number: 125037
Article Last Modified on 12/15/1999
The information in this article applies to:
- Microsoft Embedded SQL for C Programmer's Toolkit 4.22
This article was previously published under Q125037
SYMPTOMS
The /BIND option on the precompiler for Microsoft Embedded SQL for C (ESQL
for C) only builds the static stored procedures for SELECT queries. The
/BIND option fails to create stored procedures for any data modification
queries (INSERT, UPDATE, or DELETE).
CAUSE
The ESQL for C precompiler (SQLPREP.EXE and NSQLPREP.EXE) is not correctly
generating the .BND output file for queries that perform data modification.
WORKAROUND
Use the /SQLACCESS option on the precompile of your ESQL for C application.
If you need to transfer the stored procedures created by the precompiler to
another SQL Server installation, use SQL Object Manager's schema generator
to create a script file of the necessary stored procedures.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Embedded SQL for
C Programmer's Toolkit version 4.22. We are researching this problem and
will post new information here in the Microsoft Knowledge Base as it
becomes available.
Additional query words: Windows NT
Keywords: kbprogramming KB125037
Technology: kbAudDeveloper kbSQLeMCPTK422 kbSQLEmCPTKSearch kbSQLServSearch