FIND mode not working

[Joe Boyle]

it could also be that the 'reset at' timing for the temp item is different
from the original source code, check and change this if you need to.

It might be that you will have to manually cut and paste all of the
procedural code from the original source into the Axiant screen's 'screen
procedure' tab.

Regards, Joe.


-----Original Message-----
From: Joe Boyle [mailto:atla38 at dsl.pipex.com] 
Sent: 21 July 2005 13:05
To: 'Syed Shahul Hameed Mustaffa'
Cc: 'powerh-l at lists.sowder.com'
Subject: RE: FIND mode not working

Hi Syed,

you could also create the .qkr file and compare the code it contains with
the code you have in your original source file - then simply add anything
not there already. 

I seem to recall that Axiant could be a little vague/loose when generating
some procedure sections.

Regards, Joe.


-----Original Message-----
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
Deskin, Bob
Sent: 21 July 2005 12:16
To: Syed Shahul Hameed Mustaffa
Cc: powerh-l at lists.sowder.com
Subject: RE: FIND mode not working

I've come into this late so if something here has already been mentioned, my
apologies.

Your code would help because we don't know what you've done with the PATH
procedure.

By default, QDESIGN generates a PATH procedure to request index segment
values and a FIND procedure to do the retrieval based on the values entered.
If you look at a default PATH procedure you'll see that based on the entered
values, the PATH item is set. PATH is then used to determine which of many
possible retrieval methods is used in the FIND procedure.

In Select mode, there is an additional step between the PATH and FIND
procedures where QUICK prompts for selection values. There is an optional
SELECT procedure that you can code but it's normally not needed.

When you enter F or S in the action field, QUICK executes the PATH procedure
(and does selection if you entered S) and if the PATH procedure is
successful, continues on to the FIND procedure to retrieve data. If the PATH
procedure issues an error, things stop there.

Putting REQUEST verbs in the FIND procedure is actually too late. The
REQUEST verb is special in that it prompts for the data in the field buffer
but also puts the value in a special request buffer to be used for the
retrieval. This is because it is possible to change the values originally
prompted for. So a save area is needed for subsequent retrieval.

The way QUICK is designed to work is to establish your retrieval path in the
PATH procedure and the do the retrieval in the FIND procedure.

By the way, have you used the QUICK debug trace to see what's happening with
the data you've entered.

Regards

Bob

-----Original Message-----
From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com]On
Behalf Of Syed Shahul Hameed Mustaffa
Sent: July 21, 2005 4:48 AM
To: Joe Boyle
Cc: powerh-l at lists.sowder.com
Subject: Re: FIND mode not working


Dear Joe,

I cannot remove the existing FIND procedure. There are application
logic built into it.
I am explaining the scenario in a better fashion underneath. I'm
trying as much not to confuse. If u still require the code (which is
simple), I'll post it.

In the original code, the FIND procedure calls an internal procedure
called GETPARAMS.
This procedure contains the REQUEST statements. Based on what I enter
on the REQUEST fields, a temporary variable called TCOMPUTER is set to
a value.

With this code, when i execute the screen and try to select FIND mode,
it does not work. However when, I moved the GETPARAMS procedure to the
PATH procedure, I can get the screen in select mode. I can enter the
parameters and everything seems to be ok. But the problem starts when
I hit the ENTER Key to initiate the data retrieval. The TCOMPUTER
value set by the PATH procedure gets lost (reset to 0) when the
control reaches the FIND procedure. In the find procedure, I have a
GET statement that uses this TCOMPUTER to search for records. I tried
hardcoding the TCOMPUTER value that I lose on the transit, and the
search works fine. I searced in vain for any intermediate code that
resets the value of TCOMPUTER.

Pls. give me some insight about what happens between PATH and FIND
procedure calls.

Thankyou somuch.
Syed


On 7/20/05, Joe Boyle <atla38 at dsl.pipex.com> wrote:
> Hi Syed,
> 
> You don't give any details of the access syntax you have coded against the
> table so it is difficult to suggest much.
> 
> Try clicking on the path icon to create one; incidentally why do you think
> that there isn't one and have you coded your own find procedure ?
> 
> As for the 'list detail' equivalent, you have to turn (or it is easier if
> you turn on) 'keep temp files' in the build profile. You then add syntax
> like ' set list sql list transaction detail procedures' into the set
> statement of the screens identity tab. You then commit the repository and
> then recompile the screen.  I believe that the procedural code will then
be
> found in the .qkr file in the build location.
> 
> Regards, Joe.
> 
> 
> -----Original Message-----
> 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
> Syed Shahul Hameed Mustaffa
> Sent: 20 July 2005 15:37
> To: Joe Boyle
> Cc: powerh-l at lists.sowder.com
> Subject: FIND mode not working
> 
> Dear Joe,
> 
>  In a screen I have a FIND procedure. However the FIND mode is not
working.
> I found that there is no PATH procedure. Have you encountered such a
> scenario?
> 
> Dear Gurus,
> 
> If there is anyone who has encountered this scenario, pls help.
> 
> 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. 
  
       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.