FW: GET VIAINDEX question

Thu Dec 1 06:38:51 CST 2005

One other option would be to, 

1.	create an alias designer file to the table
2.	retrieve the alias file row using the ascending key detail from the
retrieved descending order row
3.	update the alias row and then use 'put . reset'

Regards, Joe. 

  _____  

From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Joe Boyle
Sent: 01 December 2005 11:34
To: 'Syed Shahul Hameed Mustaffa'
Cc: powerh-l at lists.sowder.com
Subject: RE: FW: GET VIAINDEX question

Unfortunately I don't have access to this setup so can't really add much
more. 

Usually, if you can retrieve the row ( in a standard screen ) then the row
is updatable - so long as your index is unique.

Can you run the update successfully from within Query analyzer, or even from
an Axiant screen when retrieving via the ascending index ?

Perhaps you should try the cursor approach with a 'key' phrase and orderby
syntax.

Regards, Joe. 

  _____  

From: Syed Shahul Hameed Mustaffa [mailto:sshahulgm at gmail.com] 
Sent: 01 December 2005 10:55
To: Joe Boyle
Cc: powerh-l at lists.sowder.com
Subject: Re: FW: GET VIAINDEX question

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 <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 <mailto:sshahulgm at gmail.com>  Shahul Hameed Mustaffa 

To: Joe <mailto:atla38 at dsl.pipex.com>  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
<mailto:'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/8ba0d042/attachment.html