nfxprv.ec

封装了数据库的基本操作

/*****************************************************************************/
/*                   Database Public Function For Informix                   */
/* ------------------------------------------------------------------------- */
/*  Author : Shih Ho                                                         */
/*  Date   : March 27, 1998                                                  */
/*****************************************************************************/

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <memory.h>
$include sqlca.h;
$include sqlda.h;
$include "dblib.h";
$include "nfxprv.h";

/*===========================================================================*/
/* Data Area                                                                 */
/*---------------------------------------------------------------------------*/
static long CsrCnt = 0;

/*===========================================================================*/
/* Public Funciton - Get Sequence Number                                     */
/*---------------------------------------------------------------------------*/
long GetSequence()
{
  CsrCnt ++;
  return( CsrCnt );
}

/*===========================================================================*/
/* Public Funciton - Get Field Count Of A Command                            */
/*---------------------------------------------------------------------------*/
long GetFieldCount( Command, ObjName )
EXEC SQL BEGIN DECLARE SECTION;
char *Command;
char *ObjName;
EXEC SQL END DECLARE SECTION;
{
  long FldCnt;
  struct sqlda *CntDat;

  EXEC SQL PREPARE :ObjName FROM :Command;
  if( sqlca.sqlcode == SQLOK ){
    EXEC SQL DESCRIBE :ObjName INTO CntDat;
    if( sqlca.sqlcode == SQLOK ){
      FldCnt = CntDat->sqld;
      free( CntDat );
      return( FldCnt );
    }
    EXEC SQL FREE :ObjName;
  }
  return( -1 );
}

/*===========================================================================*/
/* Public Funciton - Set Field List By Field Count                           */
/*---------------------------------------------------------------------------*/
void SetFieldList( char *Buffer, long FldCnt )
{
  int i;

  for( i = 0; i < FldCnt; i ++ ){
    *Buffer = '?';
    Buffer ++;
    if( i < FldCnt - 1 ){
      *Buffer = ',';
      Buffer ++;
    }
  }
}

/*****************************************************************************/