INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SET DESCENDING COMIX RDD vs Advantage CA-Clipper RDD

SET DESCENDING COMIX RDD vs Advantage CA-Clipper RDD

(OP)
Can anyone tell me  is it a good way to migrate from SET DESCENDING  COMIX RDD to Advantage CA-Clipper RDD where
the following CA-Clipper 5.x functions or commands are  not supported  with Advantage:    
  1) The SET DESCENDING command is not supported.
  2) The ordDescend() function is not supported.
We using this function allot especialy with reporting.
Thank you in advance.  

RE: SET DESCENDING COMIX RDD vs Advantage CA-Clipper RDD

Write your own DESCENDING() function, or use the built-in Descend() function to 'revert' your keys. I guess for the ordDescend() there's no real alternative.

HTH
TonHu

RE: SET DESCENDING COMIX RDD vs Advantage CA-Clipper RDD

(OP)
Does it means that new index could be created?
In other words does it affect index order for other users.
     "DESCENDING specifies that the index is to be built in decreasing order of value.  Using this keyword is the same as specifying the DESCEND() function within <expKey>, but without the performance penalty during index updates.  
If you create a DESCENDING index, you won't need to use the DESCEND() function during a SEEK.  DESCENDING is an attribute of the index file, where it is stored and used for REINDEXing purposes.
     This example uses DESCEND() in an INDEX expression to create a descending order date index:
        USE Sales NEW
        INDEX ON DESCEND(OrdDate) TO SalesDate

        Later, use DESCEND() to SEEK on the descending index:

        SEEK DESCEND(dFindDate)"(Guide to Ca-Clipper5.2)
Does it mean that  DBSEEK (dFindDate) should work for ascend and  DBSEEK DESCEND(dFindDate) for descend?
Thank you.

 

RE: SET DESCENDING COMIX RDD vs Advantage CA-Clipper RDD

A couple of thoughts, if you use the descend function, it can cause problems with an external module that doesn't have the descend function complied into the EXE, but has to read the index.   I've bumped into that one.   You can also go old school and subtract the date from a large number, that will also get you in reverse order.

Jim C.
 

RE: SET DESCENDING COMIX RDD vs Advantage CA-Clipper RDD

(OP)
    Can we change the ascending/descending at runtime only?
(i.e., it does not change the descending flag stored on disk for the file).
Is it possible to replace this COMIX function :    cmxDescend( [nOrder | cTag [, cBag [, lDescend]]] ) -> lPrevDescend ?
Thanks.

RE: SET DESCENDING COMIX RDD vs Advantage CA-Clipper RDD

(OP)
To write own DESCENDING() function - does it mean this could be a wrapper , or any example,please.
Thank you.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close