] 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 #0.
237
If I change the filename to something
-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
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,
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 LIST.3 and LIST.4 show up in loops such as
-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Friday, July 29, 2011 3:14 PM
To: U2 Users List
Subject: [U2] UniBasic SELECT
In an inherited legacy app, I have a few commands like
LIST.1 = 1
LIST.2 = 2
LIST.3
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
, 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
...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: 29 July 2011 23:14
To: U2 Users List
Subject: [U2] UniBasic SELECT
In an inherited legacy app, I have a few commands like
LIST.1 = 1
LIST.2 = 2
LIST.3 = 3
LIST.4 = 4
SELECT
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
[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
You can use EVAL in your select to do what you want for the MCU ...
+---
---+
|
|
| EVAL
|
|
|
| _
|
|
|
|
|
|Use in any RetrieVe sentence to introduce
@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
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 be used to facilitate
: Wednesday, May 30, 2007 1:28 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] unibasic select woes
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
@listserver.u2ug.org
Subject: [U2] unibasic select woes
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
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
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
.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber
Sent: Wednesday, May 30, 2007 1:28 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] unibasic select woes
How does one select alpha-numeric data from a unidata datafile using
SELECT when the case
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...'
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
to evaluate using the u parser.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber
Sent: Wednesday, May 30, 2007 1:28 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] unibasic select woes
How does one select alpha-numeric data from a unidata datafile
; 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
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 alpha-numeric data from a unidata datafile using
SELECT when the case of the text is not known?
I have tried
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...'
-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
25 matches
Mail list logo
