SEO

#1 (**permalink**) 04-09-2008, 11:38 PM

Hello,

I am having an error 91.

I have user input, which i am storing in a variable.
On the procedure editor im linking a transaction and a contract table
using the for each statement. I then have an IF THEN statement : If
variable = 'xxx' then FIND table structure NO-ERROR.

When i run the procedure it comes up with the error :
No STRUCTURE record is available (91)

Can anyone assist me
Thanks
Yatin

#2 (**permalink**) 04-09-2008, 11:38 PM

Yatin Soni Wrote:
> Hello
>
> I am having an error 91
>
> I have user input, which i am storing in a variable
> On the procedure editor im linking a transaction and a contract tabl
> using the for each statement. I then have an IF THEN statement : I
> variable = 'xxx' then FIND table structure NO-ERROR
>
> When i run the procedure it comes up with the error
> No STRUCTURE record is available (91
>
> Can anyone assist m
> Thank
> Yatin
if not available structure
the
.....................

also will "Find table structure NO-ERROR." even compile

--
cecsn
-----------------------------------------------------------------------
cecsno's Profile: http://www.progresstalk.com/member.p...nfo&userid=423
View this thread: http://www.progresstalk.com/showthre...?threadid=7150

#3 (**permalink**) 04-09-2008, 11:38 PM

If you post the FOR EACH loop into this forum we might be able to poin
out the exact problem because you've been a little vague with you
question :awink

--
Kirmi
-----------------------------------------------------------------------
Kirmik's Profile: http://www.progresstalk.com/member.p...nfo&userid=609
View this thread: http://www.progresstalk.com/showthre...?threadid=7150

#4 (**permalink**) 04-09-2008, 11:38 PM

Kirmik <Kirmik.157u5m@progresstalk.com> wrote in message news:<Kirmik.157u5m@progresstalk.com>...
> If you post the FOR EACH loop into this forum we might be able to point
> out the exact problem because you've been a little vague with your
> question :awink:

Thanks guys

I tried the ' if available structure then ' and it works!!

Just another question: Are there any general tips to make queries run
faster when running across a DB that is very very big?

#5 (**permalink**) 04-09-2008, 11:38 PM

soni1000@webmail.co.za (Yatin Soni) wrote in
news:7be6da7c.0404260519.576c0de0@posting.google.c om:

> Kirmik <Kirmik.157u5m@progresstalk.com> wrote in message
> news:<Kirmik.157u5m@progresstalk.com>...
>> If you post the FOR EACH loop into this forum we might be able to
>> point out the exact problem because you've been a little vague with
>> your question :awink:
>
> Thanks guys
>
> I tried the ' if available structure then ' and it works!!
>
> Just another question: Are there any general tips to make queries run
> faster when running across a DB that is very very big?
>

Lots. You need to be more specific.. Some query tuning will not do much for
certain queries. YMMV.. Check the docs at
http://www.progress.com/products/doc...tion/index.ssp

Kevin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Progress Error