It maybe how you cut and pasted.....
SELECT custno, invno, sdate, idtrans, invamt, payamt, chkno, +
chkdate, syear, speriod, batchno,timedate,csr FROM armbatch ORDER
BY idtrans ASC
chkdate, syear, speriod, batchno,timedate,csr FROM armbatch ORDER
BY idtrans ASC
There is no "+" after ORDER (see below)
SELECT custno, invno, sdate, idtrans, invamt, payamt, chkno, +
chkdate, syear, speriod, batchno,timedate,csr FROM armbatch ORDER +
BY idtrans ASC
chkdate, syear, speriod, batchno,timedate,csr FROM armbatch ORDER +
BY idtrans ASC
-------- Original Message --------
Subject: [RBASE-L] - Order By
From: Dan <[email protected]>
Date: Mon, February 15, 2010 4:47 pm
To: [email protected] (RBASE-L Mailing List)
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.
================================================
