Bjorn - What is the HFSA error? Could that be resetting it?
AFAIK, the SETTING clause copies the result of @SYSTEM.RETURN.CODE. That is set to the return value of the last command processed: for a SELECT, this happens to be the same as the number of records selected, but for any other statement it is the statement return status. If you are executing several statements together, it will be the return value of the last statement. The @SELECTED retains the last number of records selected. Brian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bjorn Behr Sent: 15 October 2004 12:52 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Strange Select Results? If I did it corrently - this is what I get: Tcl Statement = SELECT PU.SHIP.TIMES WITH ITEM = "111622" AND STATUS <= "4" Select Y = -1 Select X = ~1 record(s) selected to SELECT list #0.~Verb "HFSA" is not in your VOC.~ @SELECTED = 1 @SYSTEM.RETURN.CODE = 0 Does this help? Bjorn -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 15 October 2004 01:11 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Strange Select Results? Bjorn, 1. Is there anything that your ITEM or STATUS dictionaries might be doing that could reset @SYSTEM.RETURN.CODE? 2. What does @SELECTED read after the select? Brian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bjorn Behr Sent: 15 October 2004 11:47 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Strange Select Results? If I run the select from TCL - It returns 1 (which is correct) Does not give any error messages. Bjorn -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid Sent: 14 October 2004 04:09 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/ ________________________________________________________________________ This email was checked by MessageLabs SkyScan before entering Microgen. ________________________________________________________________________ This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk ------- 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/ ________________________________________________________________________ This email was checked by MessageLabs SkyScan before entering Microgen. ________________________________________________________________________ This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
