peoplecode中SQL的使用

Sql主要用来实现当返回结果为多行的select情况这是它和sqlexec之间的区别,

使用fetch()方法可以将sql查询出来的数据取出来例如:

&mySql = CreateSQL("Select * from " | &TableName);

&rec = CreateRecord(Record.HTR_3304_ORDERH);

While &mySql.Fetch(&rec)

  Field.HTR_3304_CUS_ID.Value = &rec.HTR_3304_ORDER_ID.Value;

  &temp = &temp | &rec.HTR_3304_ORDER_ID.Value | "";

End-While;