GET VIAINDEX question

[Joe Boyle]

this method would require an 'orderby srt_item descending' statement also - I always found it easiest to place it on the access statement and let Axiant generate the open/fetch syntax 
  ----- Original Message ----- 
  From: Joe Boyle 
  To: Syed Shahul Hameed Mustaffa ; Joe Boyle 
  Cc: powerh-l at lists.sowder.com 
  Sent: Wednesday, November 30, 2005 4:58 PM
  Subject: Re: GET VIAINDEX question


  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.



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


  -- 
  = = = = = = = = = = = = = = = = = = = = = = = = = = = =
  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/3d9d87ec/attachment.htm