[progress Communities] [progress Openedge Abl] Forum Post: Re: Prodataset Question...

  • Thread starter Thread starter Frank Meulblok
  • Start date Start date
Status
Not open for further replies.
F

Frank Meulblok

Guest
[quote user="Darrick Bush"] Please review the code below...my question is in regards to the "FILL-WHERE-STRING". I want to be able to have a where clause on the srceidlu AND another one for the xacctref. I need "srceidlu.systype = "PAS" and xacctref.acct = 29 Is this possible...and if so, how? ... DEFINE DATA-SOURCE dsAcctCrossRef FOR xacctref. DEFINE DATA-SOURCE dssrceidlu FOR srceidlu. BUFFER ttAcctCrossRef:HANDLE:ATTACH-DATA-SOURCE (DATA-SOURCE dsAcctCrossRef:HANDLE). BUFFER ttsrceidlu:HANDLE:ATTACH-DATA-SOURCE (DATA-SOURCE dssrceidlu:HANDLE). ASSIGN hbfttAcctRef = BUFFER ttAcctCrossRef:HANDLE. BUFFER ttAcctCrossRef:HANDLE:BATCH-SIZE = iBatchSize. DATA-SOURCE dssrceidlu:FILL-WHERE-STRING = SUBSTITUTE("WHERE srceidlu.systype = '&1'","PAS"). ... [/quote] Since you're using two datasources for the 2 different tables, specifying an appropriate fill-where-string for each of them should work. In this case that'd be adding a line: DATA-SOURCE dsAcctCrossRef:FILL-WHERE-STRING = SUBSTITUTE("WHERE xacctref.acct = &1","29"). somewhere before the FILL().

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