Thanks - A CLEARDATA took it away & returned the correct result. Thanks all hwo helped Bjorn
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: 15 October 2004 02:14 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Strange Select Results? This bit isn't right. Is the data stack clear before you do the execute? ~1 record(s) selected to SELECT list #0.~Verb "HFSA" is not in your VOC.~ -----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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. ------- 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/