This is a strange one:
SELECT custno, invno, sdate, idtrans, invamt, payamt, chkno, +
chkdate, syear, speriod, batchno,timedate,csr FROM armbatch ORDER
BY idtrans ASC
shows No Rows (actually 2614 rows exist)
SELECT custno, invno, sdate, idtrans, invamt, payamt, chkno, +
chkdate, syear, speriod, batchno,timedate,csr FROM armbatch
shows 2614 rows
The order by is the only difference.
IDTRANS is a column that holds the text values, "Invoice" or "Payment" etc..
This program has worked every day for a long time, till today, and
this is what I have it traced to. It can't process the data, because
it doesn't find any.
Can you think of any reason the ORDER BY IDTRANS ASC would be a
problem today?
One last piece of data for you. Today and once each month for sure,
IDTRANS holds only "Invoice" but should that matter? We run this
batch program every day to close out our daily financials. Today it failed.
Dan
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
