ProC problem

From: Steven Egberghs (PEC Info) <steven.egberghs_at_advalvas.be>
Date: Wed, 10 Jun 1998 16:41:12 +0100
Message-ID: <357E9AC3.1F8A45F2@advalvas.be>

Hello,

I declare some host variables but when debug they are not filled in with the values from the struct (see code).
Am I doing something wrong ???
Thanks
Steven

---

<snip>

EXEC SQL INCLUDE SQLCA; EXEC SQL BEGIN DECLARE SECTION;

        char    v_Shoporder   [SO_PC_SHOPORDER_LEN+1];
        char    v_ProductCode [SO_PC_PRODUCTCODE_LEN+1];
        char    v_Date_1      [SO_PC_DATERELEASE_LEN+1];
        char    v_Date_2      [SO_PC_DATERELEASE_LEN+1];
     float   v_Q_Requested ;
     float   v_Q_Finished ;

EXEC SQL END DECLARE SECTION;

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

• Function Name: InsertInto_SO_PC
  *
  
• var in : a struct, holding all the variables to be inserted
  *
  **********************************************************************/
  int InsertInto_SO_PC (struct ORA_SO_PC *Ora_So_Pc ) {

 /* copy the parameters into the host variables */

 strcpy(v_Shoporder,Ora_So_Pc->Shoporder);
 strcpy(v_ProductCode,Ora_So_Pc->ProductCode);
 strcpy(v_Date_1,Ora_So_Pc->DateRelease);
 strcpy(v_Date_2,Ora_So_Pc->DateDue);

 v_Q_Requested=Ora_So_Pc->Q_Requested;
 v_Q_Finished=Ora_So_Pc->Q_Finished;

 /* execute the update statement */
 EXEC SQL insert into SO_PC
  values( :v_Shoporder,

             :v_ProductCode,
             to_date(:v_Date_1,'DDMMYYYY'),
             to_date(:v_Date_2,'DDMMYYYY'),
             :v_Q_Requested,
             :v_Q_Finished);

 returncode=sqlca.sqlcode;
 SQLCommit();
 return(returncode);

} Received on Wed Jun 10 1998 - 10:41:12 CDT