[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Very important message... I hoping to get as many anwser as possible plz
- Subject: Very important message... I hoping to get as many anwser as possible plz
- From: Philippe Godin <philippe.godin@VIDEOTRON.CA>
- Date: Fri, 6 Jul 2001 12:45:35 -0400
- Importance: Normal
Good day everyone,
We need to get as many replies as we can get from any of you who uses
MRO's
GMAO software called MAXIMO. During our development process of SQR reports
using BRIO, we've encountered some severe problems and would like to know if
any other users had the same and if so, how they solve it.
When using BRIO to develop reports as we use to, there's is no problem
at
all. We can run them and use the viewer to see the results, we can even
compile them without any errors generated. However, we cannot run the
report under Oracle and Maximo 4i 4.1. After analysis, we've discovered that
we can't use any special caracters such as é, è, û, °, ~, à, etc... in our
code or otherwise we get an SQR 4747 error saying "The SQT file is
corrupted,". This error is generated if any of these caracters are somehow
in the code. As an example, we can't even use simple statements such as "Let
$myvar = 'année'". This is quite a problem because we need to accents in our
columns labels, report title, etc. when developping french versions of our
reports. Moreover, on MS SQL Server 7.0 and Maximo 4i 4.1 it gets even more
complex. Again, running the reports and compiling works just fine but
running them from Maximo causes a Dr. Watson error. The error tells us that
there's an access violation somewhere in memory... We've made several tests
and everyhing seems to point out on one thing. We cannot use Begin-select
statements otherwise the error is generated. Per example, the following
piece of code alone doesn't even works:
Begin-program
begin-select
wonum
from workorder
end-select
end-program
We were wondering if any of you had this problem and would like to help
out
finding a proper solution.
Thanks to all for your support
Philippe