GET VIAINDEX question

[Joe Boyle]

I was just about to apologise for my naive suggestion made earlier, and about to suggest you use a cursor with something like the code below,

1. change the file to a cursor
2. add SQL clause like 'where ( via_item < : request_item )'

and then you tell me that the suggestion helped.

I am truly astonished :))
  ----- Original Message ----- 
  From: Syed Shahul Hameed Mustaffa 
  To: Joe Boyle 
  Cc: powerh-l at lists.sowder.com 
  Sent: Wednesday, November 30, 2005 3:00 PM
  Subject: Re: GET VIAINDEX question


  Dear Joe,

  I'm just now back from my vacation. 

  Thank you so much for your help.
  It resolved my issue.

  Best Regards,
  SYED



   
  On 11/30/05, Joe Boyle <atla38 at dsl.pipex.com> wrote: 


    or if processing many rows,



    While ret GET BREED_SUMM_D viaindex BSD_BK using TCOMPUTER orderby srt_item Descending






----------------------------------------------------------------------------

    From: Joe Boyle [mailto: atla38 at dsl.pipex.com] 
    Sent: 30 November 2005 12:59
    To: 'Syed Shahul Hameed Mustaffa'; 'powerh-l at lists.sowder.com'
    Subject: RE: GET VIAINDEX question



    How about trying something like, 



    GET BREED_SUMM_D viaindex BSD_BK using TCOMPUTER orderby srt_item Descending

    Regards, Joe. 


----------------------------------------------------------------------------

    From: Syed Shahul Hameed Mustaffa [mailto: sshahulgm at gmail.com] 
    Sent: 30 November 2005 12:41
    To: powerh-l at lists.sowder.com
    Subject: GET VIAINDEX question 



    Dear Gurus,



    Quick Intro: I have migrated an PH/MPEIX application to AXIANT4GL/PH/WINDOWS (THINCLIENT).



    I have a problem with the following GET statement



    GET BREED_SUMM_D viaindex BSD_BK using TCOMPUTER

    The GET command doesn't use the index.



    As the backwards command doesn't work with relational databases, I created an index call BSD_BK in the order i wanted.



    I'll appreciate any effort to resolve this problem.



    Thank you somuch in advance.



    Regards,

    SYED.





------------------------------------------------------------------------------


  -- 
  = = = = = = = = = = = = = = = = = = = = = = = = = = = =
  Mailing list: powerh-l at lists.sowder.com
  Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
  Unsubscribe: "unsubscribe &lt;password&gt;" in message body to powerh-l-request at lists.sowder.com
  http://lists.sowder.com/mailman/listinfo/powerh-l
  This list is closed, thus to post to the list you must be a subscriber.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20051130/92aa6caf/attachment.html