FW: GET VIAINDEX question

[Syed Shahul Hameed Mustaffa]

Dear Joe,

Your are correct.
Both the GET statement and the WHILE RETRIEVING statements seems to fetch
data.
Butwhen I try to update, the Axiant is giving me the  runtime error 'There
is no data'.
Can you help me out of this issue?

Regards,
SYED.


On 12/1/05, Hasse, Christina <Christina.Hasse at cognos.com> wrote:
>
>  Just a quick comment.  The viaindex will not work with a relational
> database, because we cannot control the decision made by the database when
> retrieving the data.   Hence, the need for the specific retrieval method of
> the orderby.
> **
> *Regards,*
>
> *Christina Hasse*
> *ADT N.A. Technical Manager*
> *COGNOS CORPORATION*
> *20 North Martingale Road, Suite 150*
> *Schaumburg, IL  60173*
> *christina.hasse at cognos.com*
>
> *Office: 847 - 285 - 2905*
> *Cell: 847 - 269 - 1909*
> *Fax: 781 - 345 - 3544*
>
> *http://powerhouse.cognos.com*
>
>  ------------------------------
> *From:* powerh-l-bounces+christina.hasse=cognos.com at lists.sowder.com[mailto:
> powerh-l-bounces+christina.hasse=cognos.com at lists.sowder.com] *On Behalf
> Of *Joe Boyle
> *Sent:* Wednesday, November 30, 2005 10:58 AM
> *To:* Syed Shahul Hameed Mustaffa; Joe Boyle
> *Cc:* powerh-l at lists.sowder.com
> *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 <sshahulgm at gmail.com>
> *To:* Joe Boyle <atla38 at dsl.pipex.com>
> *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<'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.
>
>
>        This message may contain privileged and/or confidential
> information.  If you have received this e-mail in error or are not the
> intended recipient, you may not use, copy, disseminate or distribute it; do
> not open any attachments, delete it immediately from your system and notify
> the sender promptly by e-mail that you have done so.  Thank you.
>
>
>
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> 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/20051201/39a36fd6/attachment.html