請(qǐng)教一個(gè)PRO×C的問(wèn)題

zhjl1314

。。。。

EXEC SQL UPDATE tablename SET
      status = :status,
      modify_time = to_date(:upTime, 'yyyymmddhh24miss')
WHERE number = :number;

。。。。。

其中數(shù)據(jù)在其他幾個(gè)中間表中同樣存在

能不能把tablename改為一個(gè)變量用？

哪位大俠指點(diǎn)一二?

ssstar

strcpy(sqlstr,"UPDATE " );
strcpy(sqlstr,vtablename );
strcpy(sqlstr,"modify_time = to_date(:upTime, 'yyyymmddhh24miss')"  );
strcpy(sqlstr,"WHERE number = :number; "   );
strcpy(sqlstr,"..." );

EXEC SQL sqlstr using : ... ,:...,;