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
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
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
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
