[U2] RE: TCL literal select

2008-08-13 Thread Anthony Youngman
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

[U2] RE: TCL literal select

2008-08-13 Thread Anthony Youngman
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

RE: [U2] RE: TCL literal select

2008-08-13 Thread Bruce Ordway
: 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

RE: [U2] RE: TCL literal select

2008-08-13 Thread Bill Haskett
- [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

[U2] RE: TCL literal select and SQL Injection

2008-08-13 Thread Tony G
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

[U2] RE: TCL literal select

2008-08-12 Thread Israel, John R.
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,