Forum Post: RE: Self join in Open edge

  • Thread starter Thread starter jasdeep
  • Start date Start date
Status
Not open for further replies.
J

jasdeep

Guest
Another question. How can the self join for each statement can be presented using DYNAMIC-FUNCTION . In other words , How can we SET THE SDO's WHERE CLAUSE, AND OPEN THE QUERY with SELF JOIN . DYNAMIC-FUNCTION('addQueryWhere' IN h_sdo_For_RFTable, cWhereClause, "", ""). DYNAMIC-FUNCTION('openQuery' IN h_sdo_For_RFTable). Basically I need to display records in the smart data browser . The following code works in procedure editor . define buffer x2 for RFSourceHistory. for each RFSourceHistory where date(RFSourceHistory.DATE_Time_Updated) = DATE("03/26/2009"): FOR EACH x2 WHERE x2.Source_Id = RFSourceHistory.Source_Id and (x2.QSA_Approved = YES OR x2.QSA_Approved = NO) BY x2.SOURCE_Id BY x2.DATE_Time_Updated: DISPLAY x2 EXCEPT comment WITH STREAM-IO WIDTH 100. END. END. I highly appreciate your help. Thanks

Continue reading...
 
Status
Not open for further replies.
Back
Top