Hi Chris -
Being a man of my word, here I stand with hat in hand hoping you can provide me some further direction. I feel like I'm getting close, but that is not enough.
I did find the "Processes associated with the Looper controls" section in the documentation which helped
I've a query over a 4 record file, I want to see the date which is linked to the date-field in the file record, and the day-of-the-week which I'll place in the record with my code
File record dates are 09/20/2012 08/18/2012 07/12/2012 07/11/2012
my code is in the ..Row Display of Loop_QRY_TxnDay_Summary.. event/embed-point
// Load the Loop.DayOfWeek field
sLcl_DateString is string
sLcl_DateString = DateToString(QRY_TxnDay_Summary.PTX_TxnDate,"YYYYMMDD")
Info(sLcl_DateString)
SWITCH DateToDay(QRY_TxnDay_Summary.PTX_TxnDate)
CASE 1: QRY_TxnDay_Summary.PTX_TxnDate_DOW = "MOmo"
CASE 2: QRY_TxnDay_Summary.PTX_TxnDate_DOW = "TUtu"
CASE 3: QRY_TxnDay_Summary.PTX_TxnDate_DOW = "WEwe"
CASE 4: LOOP_QRY_TxnDay_Summary.PTX_TxnDate_DOW = "THth"
CASE 5: LOOP_QRY_TxnDay_Summary.PTX_TxnDate_DOW = "FRfi"
CASE 6: LOOP_QRY_TxnDay_Summary.PTX_TxnDate_DOW = "SAsa"
CASE 7: LOOP_QRY_TxnDay_Summary.PTX_TxnDate_DOW = "WNsn"
OTHER CASE: LOOP_QRY_TxnDay_Summary.PTX_TxnDate_DOW = "????"
END
Each of the dates is displayed in the Info-message, but the query list looks like this
.. 09/20/2012 THth
.. 08/18/2012
.. 07/12/2012
.. 07/11/2012
The 9/20/2012 Thursday is right, the other dates ARE shown in the Info-message and in the list but have no day of the week shown.
Any input will be GREATLY appreciated.
Guy
Chris du Toit wrote in news message <bc978507db2b2459291e872f8a2e7168@news.pcsoft>:
The best way to learn how a looper works is to start by using one that is automatically filled from a data file (select that option on your looper).
That way you don't need to use a FOR/EACH. If you want to fill it manually, then you can use that loop construct.
You can manipulate the values before being dispayed in the onRowDisplay event of the looper which is called right before each row is drawn.