PRB: Microsoft ESQL for C Generates Compiler Error w/ an Array

• Microsoft Embedded SQL for C Programmer's Toolkit, version 6.5

SYMPTOMS

The Visual C/C++ compiler generates the following compile error.

   error C2231: '.iValue' : left operand points to 'struct', use ->

   //
   // Retrieves one row of results. The SELECT INTO statement is also a
   // singleton select
   EXEC SQL select iID
         INTO :gTest[iCount].iValue
         FROM tblTest
         where iID = 1;

CAUSE

The current version of the NSQLPREP utility is not designed to handle array structures.

WORKAROUND

To work around this problem, use a pointer as shown by the following code:

   EXEC SQL begin declare section;

      typedef struct   stTest
      {
         int   iValue;
      }   TEST;

      TEST *   pCurrent   =   NULL;

   EXEC SQL end declare section;
      .
      .
      .

   //
   // Can use a pointer to fill array
   pCurrent =  &gTest[iCount];

   //
   // Retrieves one row of results. The SELECT INTO statement is also a
   // singleton select
   EXEC SQL select iID
         INTO :pCurrent->iValue
         FROM tblTest
         where iID = 1;