Report error - unable to fetch next db record = THANKS

Thanks for all your help. I am still learning about all this stuff
and you help is much appreciated.

Lucas Gourley
Hello all,

I am trying to right a report but i am receiving an error when I go
to preview it. The error is " Unable to fetch next database record.
Database error is: **"db/trg/prempmas/find.p" was not found". (293)


Any ideas would be helpful.

Lucas Gourley

lgourley@...
Due to security on the table PrEmpMas you cannot run Report Builder reports
on it. If you are Payroll Manager you can export the table. I believe you
can use Results as well.


_________________
John Koppes
Systems Coordinator
PRECISION MACHINE AND MANUFACTURING COMPANY
Address: PO Box 157
Story City, Iowa 50248
Phone: (515) 733-5181 Ext. 256
Fax: (515) 733-4220
Email: jkoppes@...



lgourley@grim
mbros.com To: vantage@egroups.com
cc:
12/08/00 Subject: [Vantage] report error - unable to fetch next db record
11:46 AM
Please
respond to
vantage






Hello all,

I am trying to right a report but i am receiving an error when I go
to preview it. The error is " Unable to fetch next database record.
Database error is: **"db/trg/prempmas/find.p" was not found". (293)


Any ideas would be helpful.

Lucas Gourley

lgourley@...



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link
above will work the next time you try it.)




______________________________________________________________________


This document should only be read by those
persons to whom it is addressed and is not intended to be relied upon by
any person without subsequent written confirmation of its contents.
Accordingly, PRECISION MACHINE AND MANUFACTURING COMPANY disclaims all
responsibility and accepts no liability, including in negligence, for the
consequences for any person acting, or refraining from acting, on such
information prior to the receipt by those persons of subsequent written
confirmation.

If you have received this E-mail / Fax
message in error, please notify PRECISION MACHINE AND MANUFACTURING COMPANY
immediately by telephone. Please also destroy and delete the message.

Contact:
By Phone: Systems
Administrator at (515)-733-5181
By Email:
sysadmin@...

Any form of reproduction, dissemination,
copying, disclosure, modification, distribution and/or publication of this
E-mail / Fax message is strictly prohibited.
Lucas,

You cannot access PR records from Report Builder. You must
use the export utility.


have fun,
John


> -----Original Message-----
> From: lgourley@... [mailto:lgourley@...]
> Sent: Friday, December 08, 2000 9:47 AM
> To: vantage@egroups.com
> Subject: [Vantage] report error - unable to fetch next db
> record
For $100 Tom McLeary of Advanced Research can make all payroll
records available to Report Builder. You will still have
security too. Call Tom at (419) 842-1144 if you are interested.

lgourley@... wrote:
>
> Hello all,
>
> I am trying to right a report but i am receiving an error when I go
> to preview it. The error is " Unable to fetch next database record.
> Database error is: **"db/trg/prempmas/find.p" was not found". (293)
>
> Any ideas would be helpful.
>
> Lucas Gourley
>
> lgourley@...
>
>
> We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)
This is a pathing problem.

There is a find trigger defined for the record that you are trying to retrieve, but progress cannot find the file. There are two solutions to this problem. The trigger root needs to be added to the PROPATH variable, or you need to start your session with the -trig
parameter. Both of these will work for a regular progress session, but I don't have any the Report Builder Documentation handy, so I can't tell you if you can use this is one of the parameters the Report Builder can use. However setting the PROPATH variable will
probably do the trick.

HTH.

lgourley@... wrote:

> Hello all,
>
> I am trying to right a report but i am receiving an error when I go
> to preview it. The error is " Unable to fetch next database record.
> Database error is: **"db/trg/prempmas/find.p" was not found". (293)
>
> Any ideas would be helpful.
>
> Lucas Gourley
>
> lgourley@...
>
>
> We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)

--
/* ============================================================== */

William E. Colls Tel 613 591 0079
PROComputer Systems Fax 613 591 3924
67 Willow Glen Dr www.procomsys.com
Kanata Ontario Canada PEG Member 1998051404

Specialists in Progress Software development since 1985
William,

It may in fact be a pathing problem, but it results because
the Payroll tables, by design, are inaccessible from Report
Builder because of Vantage program security.

have fun,
John


> -----Original Message-----
> From: William Colls [mailto:william@...]
> Sent: Friday, December 08, 2000 10:23 AM
> To: vantage@egroups.com
> Subject: Re: [Vantage] report error - unable to fetch next
> db record
>
>
> This is a pathing problem.