Hi Chris:
This is a problem we first tried to figure out when we went to the Web. The
easiest way for us was to save off the client select using SAVE.LIST. You
will need a few variableS to keep track of where you are CURRENT.PAGE.NO,
ITEMS.PER.PAGE and NEW.PAGE.NO. Use you math skills you
Chris:
I'm betting the solution also needs indexing, because you want to pick
up where the last list left off and you don't want to wait for a select
to return to save the list. So, SAMPLE isn't really a solution but
indexing is. We do this all the time, but we have to use indexing. In
] '
Date: Wed, 20 Jul 2011 11:38:50 -0600
From: dave...@gmail.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
Hi Chris:
This is a problem we first tried to figure out when we went to the Web. The
easiest way for us was to save off the client
Bill,
I was curious if you had a quick example? I'm just curious how you guys are
suggesting to do this
Chris
Date: Wed, 20 Jul 2011 11:13:04 -0700
From: wphask...@advantos.net
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
Chris:
I'm betting
*Subject:* Re: [U2] SELECT question, paginated select.
Bill,
I was curious if you had a quick example? I'm just curious how you guys are
suggesting to do this
Chris
Date: Wed, 20 Jul 2011 11:13:04 -0700
From: wphask...@advantos.net
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question
@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
Chris:
I'm betting the solution also needs indexing, because you want to pick
up where the last list left off and you don't want to wait for a select
to return to save the list. So, SAMPLE isn't really a solution but
indexing
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
Chris:
For instance, we have checks file. A number of our clients have over a
million records in the file. It's indexed on vendor no. and check
date. The index would look like:
00CAPGE15857 (7 digit
@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
Chris,
I agree with Bill, using an index is your best solution. Are you able to
apply any kind of filter criteria to the names? If not here's one of your
dilemmas... If you make your drop down list too small nobody
: Wednesday, July 20, 2011 12:19 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
Curt,
My problem is understanding how to traverse the query. Our dropdown is
paginated, we can specify the # of results per paginated drop-down so it
being super long or short
...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Wednesday, July 20, 2011 12:19 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
Curt,
My problem is understanding how to traverse the query. Our dropdown is
paginated, we can specify the # of results per
We have had similar problems - one solution that works very well is to not
contact the database to do big selects like this. We write such data into
xml files onto the web server and make them accessible via a web service
that is cached. This speeds up performance considerably, it sounds like a
-users@listserver.u2ug.org
Date: Wed, 20 Jul 2011 12:42:10 -0700
Subject: Re: [U2] SELECT question, paginated select.
Look at the BSCAN directive. It allows you to scan and traverse B-Tree
type
files and alternate indices.
Larry Hiscock
Western Computer Services
-Original
-corp.com
To: u2-users@listserver.u2ug.org
Date: Wed, 20 Jul 2011 12:42:10 -0700
Subject: Re: [U2] SELECT question, paginated select.
Look at the BSCAN directive. It allows you to scan and traverse B-Tree
type
files and alternate indices.
Larry Hiscock
Western Computer Services
@listserver.u2ug.org
*Date:* 7/20/2011 12:04 PM
*Subject:* Re: [U2] SELECT question, paginated select.
Bill,
I guess my question is regarding how to traverse the index. In this case the
field we're using is the @ID, so it's
indexed by default. Below you stated that we have to traverse in BASIC
Which is a great thingunless you're the cat! And then, you'd pray that
a committee be setup to decide on which method to use!
As in anything with web programming (especially with MV), there are
million
ways to skin the cat. Hope that helps.
I thought we discussed this about a year ago, with the solution using SQL on UV
to do your selection, which was able to produce a row number, then only
include
certain row numbers on the final query.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
: Re: [U2] SELECT question, paginated select.
Look at the BSCAN directive. It allows you to scan and traverse B-Tree type
files and alternate indices.
Larry Hiscock
Western Computer Services
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun
Interesting, I wonder if anyone still has an example of this?
Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Wed, 20 Jul 2011 15:15:58 -0500
Subject: Re: [U2] SELECT question, paginated select.
I thought we discussed this about a year ago, with the solution
OK. Try this
ED DICT CLIENT ROW
0001: I
0002: @1+1
0003:
0004: ROW
0005: 5R
Now, you can SELECT CLIENT WITH . AND WITH ROW =1 AND ROW =20
As long as the selection stays the same, This should work.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, July 20, 2011 4:23 PM
To: U2 Users List
Subject: Re: [U2] SELECT question, paginated select.
OK. Try this
ED DICT CLIENT ROW
0001: I
0002: @1+1
0003:
0004: ROW
0005: 5R
: Wed, 20 Jul 2011 15:22:44 -0500
Subject: Re: [U2] SELECT question, paginated select.
OK. Try this
ED DICT CLIENT ROW
0001: I
0002: @1+1
0003:
0004: ROW
0005: 5R
Now, you can SELECT CLIENT WITH . AND WITH ROW =1 AND ROW =20
As long as the selection stays the same
the SQL queries
to paginate it based on row? Or is this a trick to use a UniVerse SELECT?
Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Wed, 20 Jul 2011 15:22:44 -0500
Subject: Re: [U2] SELECT question, paginated select.
OK. Try this
ED DICT
20, 2011 4:34 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
George,
Is the dictionary change below used for the SQL solution you mentioned?
In other words, do I have to add this to use the SQL queries
to paginate it based on row
names. Not what you asked for.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, July 20, 2011 4:39 PM
To: U2 Users List
Subject: Re: [U2] SELECT question, paginated select
I just added these two items (ROW and PAGE) to my VOC, so they can be used on
any file now
although I changed the PAGE name to PAGE20, for 20 items per Page.
ED VOC ROW
001: I
002: @1+1
003:
004: ROW
005: 6R
006: S
ED VOC PAGE20
001: I
002: @1+1 ; INT((@1+1-2)/20)+1
003:
004: PAGE
005: 6R
006:
...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Wed, 20 Jul 2011 15:38:39 -0500
Subject: Re: [U2] SELECT question, paginated select.
This works with UV, and not the SQL solution.
However, I did find if you need to do a sorted select, you first have to do
the select
I've seen this technique described before but it doesn't work for me on
UD7.1. Is there a way of doing this in UniData?
Thx,
Brad.
From: George Gallen ggal...@wyanokegroup.com
To: U2 Users List u2-users@listserver.u2ug.org
Date: 07/20/2011 03:23 PM
Subject:Re: [U2] SELECT
-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
George,
I put PAGE in my CLIENT DICT so it looks like the following:
PAGE
0001 I
0002 @1+1 ; INT((@1+1-2)/20)+1
0003
0004 PAGE
0005 6R
0006 S
After I filed it I got a message stating an I
:23 PM
Subject:Re: [U2] SELECT question, paginated select.
Sent by:u2-users-boun...@listserver.u2ug.org
OK. Try this
ED DICT CLIENT ROW
0001: I
0002: @1+1
0003:
0004: ROW
0005: 5R
Now, you can SELECT CLIENT WITH . AND WITH ROW =1 AND ROW =20
As long
-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Wednesday, July 20, 2011 5:26 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
George,
I must say, you the man! And thanks for everyone
Date: Wed, 20 Jul 2011 16:32:54 -0500
Subject: Re: [U2] SELECT question, paginated select.
You understand that the value for PAGE is specific to the SELECT / LIST
which is why when you list the names, it displays as page 1, which is
based on that output. When you did the select, it pulled from
...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Wednesday, July 20, 2011 5:26 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
George,
I must say, you the man! And thanks for everyone else's help too
: Re: [U2] SELECT question, paginated select.
I'm not sure if this works on Pick flavor but...
ED VOC GETCLIENTS
001: PA
002: SELECT CLIENT BY NAME WITH NAME = I2,SRCH
003: SELECT CLIENT WITH PAGE = I2,PAGNO
NOW, You can get your results with
GETCLIENTS A 4
GETCLIENTS ALEX 6
George
-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
Thank you! We don't do a lot of double select statements in our
programs, I assume you do the 1st SELECT and then do some sort of
CAPTURED or PASSLIST command
to pass the first selected values into the 2nd SELECT
CLIENT WITH PAGE = A
Without setting up a VOC entry is there an easy way to execute 2 selects in a
program (just like in telnet)?
Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Wed, 20 Jul 2011 16:50:08 -0500
Subject: Re: [U2] SELECT question, paginated select
George,
The first example worked beautifully, thanks for all help! :)
Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Wed, 20 Jul 2011 16:58:38 -0500
Subject: Re: [U2] SELECT question, paginated select.
If your doing the selects from a Basic program
OK cool, thanks. Just out of curiosity how would you do 2 selects using a
PASSLIST?
Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Wed, 20 Jul 2011 17:06:50 -0500
Subject: Re: [U2] SELECT question, paginated select.
SORRY, My mistake.
that should have
Sent: Wednesday, July 20, 2011 6:15 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SELECT question, paginated select.
OK cool, thanks. Just out of curiosity how would you do 2 selects using
a PASSLIST?
Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
it, or is it a system level
command when you stack select's that the system processes 1 first, then the 2nd
with the first's results.
Chris
From: cjausti...@hotmail.com
To: u2-users@listserver.u2ug.org
Date: Wed, 20 Jul 2011 17:14:53 -0500
Subject: Re: [U2] SELECT question, paginated
39 matches
Mail list logo
