Dan, Is there an index on idtrans? If so,
PACK INDEX FOR armbatch (You can do this in multiuser mode) Then try again. If you have a broken index, that could explain the no rows found when there's an ORDER BY. Bill On Mon, Feb 15, 2010 at 4:47 PM, Dan <[email protected]> wrote: > 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. > ================================================ > > >
