| Author |
set order by name of index
|
|
| Andreas Moroder 2005-03-07, 3:55 pm |
| Hello,
is there a function to set the order with the name of the index as
parameter instead of the position of the index ?
Thanks
Andreas
| |
| E. Fridman 2005-03-07, 8:55 pm |
| What Clipper version? What RDD are you using?
| |
| Charles Foot 2005-03-07, 8:55 pm |
|
Andreas Moroder wrote:
> Hello,
>
> is there a function to set the order with the name of the index as
> parameter instead of the position of the index ?
>
> Thanks
> Andreas
if using .CDX you can do it thus:-
set order to OrdNumber( 'tagname' )
| |
| Bambang P 2005-03-08, 3:55 am |
| Hello Andreas,
On Mon, 07 Mar 2005 14:36:52 +0100, Andreas Moroder
<Andreas.moroder@[nospam]sb-brixen.it> wrote:
>Hello,
>
>is there a function to set the order with the name of the index as
>parameter instead of the position of the index ?
>
Have you tried OrdSetFocus( <IndexName> ) ?
--
Bambang P
http://bpranoto.tripod.com
| |
|
| On Mon, 07 Mar 2005 14:36:52 +0100, Andreas Moroder
<Andreas.moroder@[nospam]sb-brixen.it> wrote:
>Hello,
>
>is there a function to set the order with the name of the index as
>parameter instead of the position of the index ?
>
>Thanks
>Andreas
How about :
ordSetFocus(<cTagName> )
Cal
| |
| Andreas Moroder 2005-03-09, 8:55 am |
| E. Fridman schrieb:
> What Clipper version? What RDD are you using?
>
5.2e NTX
Bye
Andreas
| |
| Joe Wright 2005-03-09, 8:55 pm |
| Andreas Moroder wrote:
> Hello,
>
> is there a function to set the order with the name of the index as
> parameter instead of the position of the index ?
>
> Thanks
> Andreas
Consider..
use members
index on first_name + last_name to first
set index to
index on last_name + first_name to last
set index to first, last
...Now 'set order to first' chooses the first one and 'set order to last'
chooses the second one. 'set order to' restores members to natural order
but leaves the indexes open.
--
Joe Wright mailto:joewwright@comcast.net
"Everything should be made as simple as possible, but not simpler."
--- Albert Einstein ---
| |
| Ian Boys 2005-03-10, 3:55 am |
| I think Andreas means is there a "set order to first" function as opposed to
set order to 1
Ian
"Joe Wright" <joewwright@comcast.net> wrote in message
news:EeqdneDOWZ47G7LfRVn-pg@comcast.com...
> Andreas Moroder wrote:
>
> Consider..
>
> use members
> index on first_name + last_name to first
> set index to
> index on last_name + first_name to last
> set index to first, last
>
> ..Now 'set order to first' chooses the first one and 'set order to last'
> chooses the second one. 'set order to' restores members to natural order
> but leaves the indexes open.
>
> --
> Joe Wright mailto:joewwright@comcast.net
> "Everything should be made as simple as possible, but not simpler."
> --- Albert Einstein ---
| |
| Andreas Moroder 2005-03-11, 8:55 pm |
| E. Fridman schrieb:
> What Clipper version? What RDD are you using?
>
5.2e NTX
Bye
Andreas
| |
| Joe Wright 2005-03-12, 3:55 am |
| Andreas Moroder wrote:
> Hello,
>
> is there a function to set the order with the name of the index as
> parameter instead of the position of the index ?
>
> Thanks
> Andreas
Consider..
use members
index on first_name + last_name to first
set index to
index on last_name + first_name to last
set index to first, last
...Now 'set order to first' chooses the first one and 'set order to last'
chooses the second one. 'set order to' restores members to natural order
but leaves the indexes open.
--
Joe Wright mailto:joewwright@comcast.net
"Everything should be made as simple as possible, but not simpler."
--- Albert Einstein ---
| |
| Ian Boys 2005-03-12, 8:55 am |
| I think Andreas means is there a "set order to first" function as opposed to
set order to 1
Ian
"Joe Wright" <joewwright@comcast.net> wrote in message
news:EeqdneDOWZ47G7LfRVn-pg@comcast.com...
> Andreas Moroder wrote:
>
> Consider..
>
> use members
> index on first_name + last_name to first
> set index to
> index on last_name + first_name to last
> set index to first, last
>
> ..Now 'set order to first' chooses the first one and 'set order to last'
> chooses the second one. 'set order to' restores members to natural order
> but leaves the indexes open.
>
> --
> Joe Wright mailto:joewwright@comcast.net
> "Everything should be made as simple as possible, but not simpler."
> --- Albert Einstein ---
|
|
|
|