Rather than writing a simple program ...
SELECT PARTS WITH EVAL DCOUNT(F1, '') GT 0
Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R.
Sent: 12 August 2008 21:59
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] RE: TCL literal
Ooops ...
COUNT, not DCOUNT
Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman
Sent: 13 August 2008 12:01
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] RE: TCL literal select
Rather than writing a simple program ...
SELECT
: INDEX(F1,'',1)
003:
004:
005: 6L
006: S
-Original Message-
From: Anthony Youngman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2008 7:08 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] RE: TCL literal select
Ooops ...
COUNT
-
[EMAIL PROTECTED] On Behalf Of Bruce Ordway
Sent: Wednesday, August 13, 2008 8:26 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] RE: TCL literal select
Hi,
I ended up using this from Martin C. (of Epicor fame).
I don't know why none of the TCL examples would work for me.
Something to do
From: Bruce Ordway
I want to select all parts that have a in the description
field (F1). People have been using instead of INCH.
This causes problems for me during processing some reports
and exports.
I don't didn't get the original post to this, only replies -
weird.
What's being
I tried using the lower case SELECT/LIST to use native UniData syntax, and
that did not work.
Try writing a simple program to convert the double quotes to something else
(like a tilda) then search the I-desc for that.
ED BP TILDA
SUBROUTINE TILDA(RTN.VAL, ORIG.VAL)
RTN.VAL = CONVERT(ORIG.VAL,