Try putting the ARRANGE clause before the WHERE clause -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dick Fey Sent: Tuesday, February 19, 2008 11:10 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Arrange by
Don't you hate it when a simple command doesn't work? edit using cborder where refnum = 280183 Works as expected. but... edit using cborder where refnum = 280183 arrange orddetail by detailno gives a 'Error invalid integer value' Error 2418 Enclosing the 280183 ( it is an integer) with quotes gives 'Error invalid text value' Error 2418 I am sure I cannot see the forest for the trees. Dick Fey Carpet Broker Inc.
