Could it be because "STATUS" is a keyword? -----Original Message----- From: Mats Carlid [mailto:[EMAIL PROTECTED] Sent: Thursday, October 14, 2004 7:09 AM To: [EMAIL PROTECTED] Subject: Re: [U2] [UV] Strange Select Results?
I've never seen select reuturn status -1 except when there is a syntax error in the select command - so try rerunning without hush or run the select from the tcl to capture the error messages - if any. HTH -- mats Bjorn Behr wrote: >Why when I execute this: > >EXECUTE Tcl CAPTURING SelectX Returning SelectY > >do I get this? > >:: Tcl/ > >STRING: T r L=64 `SELECT PU.SHIP.TIMES WITH ITEM = "336DB-1.1/2" AND STATUS ><= "4"' > >:: SelectX/ > >STRING: T r L=73 `~1 record(s) selected to SELECT list #0.' > >:: SelectY/ > >NUMBER: -1 > > >Should SelectY not equal 1? >PS: It should select 1! > >System Information: >O/S: Windows 2003 >UV : UniVerse 10.1 >_______________________________________________________________________ _ >Regards >Bjvrn Behr >Programmer > >HYFLO Southern Africa (Pty) Ltd >Tel : +27 11 386 5800 >Fax : +27 11 444 5391 >Mail: [EMAIL PROTECTED] >WWW : http://www.hyflo.co.za >_______________________________________________________________________ _ >------- >u2-users mailing list >[EMAIL PROTECTED] >To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
