Re: [U2] UniBasic SELECT

2011-08-01 Thread Bill Brutzman
for the help. I appreciate it. Regards, --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Keith Johnson [DATACOM] Sent: Sunday, July 31, 2011 5:02 PM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2

Re: [U2] UniBasic SELECT

2011-08-01 Thread John Thompson
-users@listserver.u2ug.org' Subject: Re: [U2] UniBasic SELECT The problem may be in the use of program variables in the executed code. Using Universe, if I have code: VERB = 'SELECT VOC LIKE A...' EXECUTE VERB CRT @SELECTED CLEARSELECT I get the result 237 record(s) selected to SELECT list

Re: [U2] UniBasic SELECT

2011-07-31 Thread Keith Johnson [DATACOM]
The problem may be in the use of program variables in the executed code. Using Universe, if I have code: VERB = 'SELECT VOC LIKE A...' EXECUTE VERB CRT @SELECTED CLEARSELECT I get the result 237 record(s) selected to SELECT list #0. 237 If I change the filename to something that doesn't exit,

Re: [U2] UniBasic SELECT

2011-07-29 Thread Larry Hiscock
#1 - Why would you want to change a Basic SELECT to EXECUTE a SELECT? #2 - If you still want to do this, change this: Execute SELECT F.ICC to LIST.2 To this: Execute SELECT F.ICC to :LIST.2 Larry Hiscock Western Computer Services -Original Message- From:

Re: [U2] UniBasic SELECT

2011-07-29 Thread Wols Lists
On 29/07/11 23:14, Bill Brutzman wrote: In an inherited legacy app, I have a few commands like LIST.1 = 1 LIST.2 = 2 LIST.3 = 3 LIST.4 = 4 SELECT F.ICC to LIST.2 SELECT F.ICC to LIST.3 SELECT F.ICC to LIST.4 And then LIST.2

Re: [U2] UniBasic SELECT

2011-07-29 Thread Bill Brutzman
, July 29, 2011 6:37 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniBasic SELECT On 29/07/11 23:14, Bill Brutzman wrote: In an inherited legacy app, I have a few commands like LIST.1 = 1 LIST.2 = 2 LIST.3 = 3 LIST.4 = 4 SELECT F.ICC to LIST.2

Re: [U2] UniBasic SELECT

2011-07-29 Thread Symeon Breen
LIST.2 is a variable inside your databasic code. EXECUTE runs some TCL code and is not privy to your databsic variables. I presume you want to concatenate LIST.2 to the end of the execute command and not include it in the string -Original Message- From:

Re: [U2] UniBasic SELECT

2011-07-29 Thread Wols Lists
On 29/07/11 23:53, Bill Brutzman wrote: Thanks to Larry and Wol for writing. Both ways work to get rid of the red warnings but both ways I still get the pesky SQL+ prompt at the end. That sounds weird. I was wondering why the EXECUTE made the SQL+ prompt appear, but there's no way a BASIC

Re: [U2] UniBasic SELECT

2011-07-29 Thread BobW
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, July 29, 2011 3:53 PM To: U2 Users List Subject: Re: [U2] UniBasic SELECT Thanks to Larry and Wol for writing. Both ways work to get rid of the red warnings but both ways I still get the pesky SQL+ prompt at the end

RE: [U2] unibasic select woes

2007-06-01 Thread Morelli, David W.
@listserver.u2ug.org Subject: RE: [U2] unibasic select woes Greg, Actually the following in saver: SELECT HRPER WITH EVAL OCONV(HRP.LAST.NAME,'MCU') LIKE 'SC'... (note the extra ' around the text) there are a few alphanumeric characters that are interpreted by SELECT and it will show you weird results when

RE: [U2] unibasic select woes

2007-05-30 Thread Dave Davis
In ECLTYPE u SELECT HRPER WITH EVAL OCONV(HRP.LAST.NAME,'MCU') LIKE SC... If you are currently in ECLTYPE p, you can put the word SELECT in lowercase to evaluate using the u parser. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber Sent:

RE: [U2] unibasic select woes

2007-05-30 Thread Karen Bessel
Create a new dictionary item with conversion code 'MCU' pointing at the same attribute#. Use that dictionary item in your select. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber Sent: Wednesday, May 30, 2007 1:28 PM To:

Re: [U2] unibasic select woes

2007-05-30 Thread Jeff Schasny
Create an I-Type pointing to the text field that converts all the text to upper case and use it in the select I-Type: UP.HRP.LAST.NAME 001: I 002: OCONV(HRP.LAST.NAME,'MCU') 003: 004: LAST NAME 005: 25L 006: S Greg Schraiber wrote: How does one select alpha-numeric data from a unidata

RE: [U2] unibasic select woes

2007-05-30 Thread Buffington, Wyatt
Try: SELECT HRPER WITH EVAL UPCASE(HRP.LAST.NAME) LIKE 'SC...' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber Sent: Wednesday, May 30, 2007 12:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] unibasic select woes How does one select

RE: [U2] unibasic select woes

2007-05-30 Thread Greg Schraiber
Thanks Karen! Is there really no other way? Seems odd that you can't use functions in the select statement. Greg At 12:42 PM 5/30/2007, Karen Bessel wrote: Create a new dictionary item with conversion code 'MCU' pointing at the same attribute#. Use that dictionary item in your select.

Re: [U2] unibasic select woes

2007-05-30 Thread Martin Phillips
Hi Greg, Create a dictionary item named, for example, U.HRP.LAST.NAME, and defined as 001: I 002: UPCASE(HRP.LAST.NAME) Fields 3 onwards as for HRP.LAST.NAME Then do SELECT HRPER WITH U.HRP.LAST.NAME LIKE 'SC...' Alternatively, do SELECT HRPER WITH EVAL UPCASE(HRP.LAST.NAME) LIKE 'SC...'

Re: [U2] unibasic select woes

2007-05-30 Thread Allen Egerton
Greg Schraiber wrote: How does one select alpha-numeric data from a unidata datafile using SELECT when the case of the text is not known? I have tried things like: SELECT HRPER WITH UPCASE(HRP.LAST.NAME) LIKE 'SC...' but all I get is a syntax error. Can someone tell me which function(s) can

RE: [U2] unibasic select woes

2007-05-30 Thread Greg Schraiber
Dave, Wyatt Karen, Thank you so much for the tips! Works like a charm! Thanks again, Greg At 12:45 PM 5/30/2007, Dave Davis wrote: In ECLTYPE u SELECT HRPER WITH EVAL OCONV(HRP.LAST.NAME,'MCU') LIKE SC... If you are currently in ECLTYPE p, you can put the word SELECT in lowercase to

RE: [U2] unibasic select woes

2007-05-30 Thread Karen Bessel
; u2-users@listserver.u2ug.org Subject: RE: [U2] unibasic select woes Thanks Karen! Is there really no other way? Seems odd that you can't use functions in the select statement. Greg At 12:42 PM 5/30/2007, Karen Bessel wrote: Create a new dictionary item with conversion code 'MCU' pointing

RE: [U2] unibasic select woes

2007-05-30 Thread Bruce McAdoo
Create a new dictionary item like the following: ED DICT HRPER UPC.HRP.LAST.NAME 001: V 002: OCONV(HRP.LAST.NAME, MCU) 003: 004: 005: 10L 006: S SELECT HRPER WITH UPC.HRP.LAST.NAME LIKE 'SC...' Bruce W. McAdoo Wagner Brown, Ltd. [EMAIL PROTECTED] -Original Message- From: [EMAIL

RE: [U2] unibasic select woes

2007-05-30 Thread Boydell, Stuart
SELECT HRPER WITH HRP.LAST.NAME CONV MCU LIKE 'SC...' Should work. -Original Message- How does one select alpha-numeric data from a unidata datafile using SELECT when the case of the text is not known? I have tried things like: SELECT HRPER WITH UPCASE(HRP.LAST.NAME) LIKE 'SC...'

RE: [U2] unibasic select woes

2007-05-30 Thread Andre Meij
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber Sent: maandag 30 april 2007 11:12 To: u2-users@listserver.u2ug.org; u2-users@listserver.u2ug.org Subject: RE: [U2] unibasic select woes Dave, Wyatt Karen, Thank you so much for the tips