Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Per E. Johannessen

Pages: [1] 2 3 ... 16
1
Setup & Installation / Re: AOO4.11.1/Firefox/Seamonkey trouble
« on: June 08, 2023, 03:31:13 pm »
Somewhat embarrassing, but ..... I installed AOO from a directory with lots of zip and wpi files and the installation program found the file AOO-41110-GA-rpm.wpi which resulted in downgrading lots of dll's in usr\lib.  Used ANPM to update the libs mentioned in the readme.txt and the errors seem to be gone.

2
Setup & Installation / Re: AOO4.11.1/Firefox/Seamonkey trouble
« on: June 08, 2023, 01:21:08 pm »
I always get the errors when opening existing files.

Creating and saving a new spreadsheet works but reopening the new file generates the error "Not all attributes could be read".

Opening a text documents gives "General error". Creating a new text document and trying to save it also results in "General error",
still the document is saved and I can reopen it but get the general error.

3
Setup & Installation / Re: AOO4.11.1/Firefox/Seamonkey trouble
« on: June 08, 2023, 11:16:19 am »
In addition to the "Not all attributes could be read" when opening spreadsheets I also get "General error" when opening text documents.
Noticed that someone had the same problem with LibreOffice and installing another version fixed the problem.

https://bugs.documentfoundation.org/show_bug.cgi?id=72781

As far as I can see OpenOffice 4.1.11 is the latest GA-version for OS/2.

Any suggestions?

4
Setup & Installation / Re: AOO4.11.1/Firefox/Seamonkey trouble
« on: June 08, 2023, 10:45:06 am »
After updating libstdc++ there are no more SYS2070's in popup.log, (and Firefox/Seamonkey work again).

5
Setup & Installation / Re: AOO4.1.11/Firefox/Seamonkey trouble
« on: June 07, 2023, 09:14:07 pm »
I've seen only one post about this issue;
https://forum.openoffice.org/en/forum/viewtopic.php?t=68547
but he was running a beta version

Just noticed that I referred to AOO 4.11.1, should be 4.1.11 GA.


6
Setup & Installation / Re: AOO4.11.1/Firefox/Seamonkey trouble
« on: June 07, 2023, 06:47:55 pm »
Somehow I got ANPM  running again and updated libstdc++ and both Seamonkey and Firefox now seem to work.

However, with OpenOffice I still get "Not all attributes could be read"

7
Setup & Installation / Re: AOO4.11.1/Firefox/Seamonkey trouble
« on: June 07, 2023, 05:53:34 pm »
Firstly, google translation of your comment;
--
The DLL ICUUC.DLL cannot find a function in the DLL STDCPP6.DLL.
You will most likely have to install some legacy packages for one or both DLLs using yum/rpm. You may also need to use LIBPATH to ensure that the DLLs are loaded preferentially from certain directories.
You may also need to use LIBPATH to ensure that the DLLs are loaded preferentially from certain directories.
I forgot which package the icuuc DLL is in, you have to search around in the package contents.
--
Secondly, I now also have some problems with ANPM, tried to reinstall some packages nad ANPM simply closes without any message.

Entry in popuplog:
06-07-2023  16:17:15  SYS2070  PID 004b  TID 0001  Slot 0078
G:\TOOLS\ANPM\ANPM.EXE
STDCPP6->GCC1.___gthread_os2_mutex_lock
127

Don't really know where to go from here, believe I have to manually reinstall som packages, but which ones?

8
Setup & Installation / AOO4.11.1/Firefox/Seamonkey trouble
« on: June 07, 2023, 02:30:16 pm »
After installing AOO 4.11.1 I cannot start Firefox or Seamoneky.

Following from popup.log:

06-07-2023  14:11:58  SYS2070  PID 0031  TID 0001  Slot 007c
P:\SEAMONKEY\SEAMONKEY.EXE
ICUUC->STDCPP6.__ZNSt18condition_variableC1Ev
127

06-07-2023  14:12:01  SYS2070  PID 0032  TID 0001  Slot 007c
G:\PROGRAMS\FIREFOX\FIREFOX.EXE
ICUUC->STDCPP6.__ZNSt18condition_variableC1Ev
127

AOO writer/calc starts ok but when opening an existing spreadsheet I get the warning
"Not all attributes could be read"
After clicking ok on the warning the spreadsheet is displayed as normal.

Any ideas?

9
Programming / Re: SQL running total
« on: May 27, 2023, 06:51:41 pm »
Thanks for info, Doug.
I tried your SQL-statements using the drivers that are bundled with DBExpert, (from 1994) and it will not work.
Error message: "Mismatched parens". Have tried a number of variations with "(" and ")" but no success yet.
I will try some "evaluation" drivers as soon as I get the chance.
Nice to hear that your're working on a "database application". Right now I don't have the need to implement running totals through SQL.
since the Rexx script provided by Lars, in another post, works fine. 
Anyway, I'm very interested your application and will be happy to test when it is ready for that.




10
Programming / [SOLVED] Re: Rexx cumulative values
« on: May 21, 2023, 12:17:14 pm »
In case someone is interested, this code works:

   reprows = 0

ok = VRMethod( "QRY_2", "MoveFirst" )
identifier = ''
sum = 0
do while( ok = 1 )
   call VRMethod "QRY_2", "RowData", "data."
   if data.1 <> identifier then do
   identifier = data.1
   sum = data.2

   end
   else do
   sum = sum + data.2
   end
   data.3 = sum

   reprows=reprows+1
   data.reprows.TEKSTFLT = data.1
   data.reprows.TALLFLT1 = data.2
   data.reprows.AKKUM = data.3

ok = VRMethod( "QRY_2", "MoveNext" )
end

data.0=reprows

DO i=1 TO data.0

END i

hwnd = VRGet( "Window1", "HWnd" )

rc=VpPrintReport(hwnd, 'REP_HBAKKM.vpt', 'data.', '<PREVIEW>' )

11
Programming / SQL running total
« on: May 19, 2023, 05:54:52 pm »
Hi,

This statement works with SQLite;

select amount, (select sum(t2.amount) from example t2 where t2.id <= t1.id) as accumulated from example t1 order by id

Does anyone know how to make it work with dBase (IV/V)?

(I've found many examples for other databases but none of them works with dBase.)

12
Programming / Re: Rexx cumulative values
« on: May 16, 2023, 03:20:31 pm »
Well, there is only data from "QRY_2" that is being used in the report.

Writing to a txt-file is OK, like this;
        outfile = data.1 ',' data.2 ',' data.3
        out = lineout(testakkm.txt,outfile)

So, how to define the same data as source for the VPR-report REP_HBAKKM.vpt ?



13
Programming / Re: Rexx cumulative values
« on: May 15, 2023, 10:15:27 pm »
Tried to create a report, which works but it is missing the cumulative values.
I added the following to Lars' code:

    reprows = 0
ok = VRMethod( "QRY_2", "MoveFirst" )
do while( ok = 1 )
    call VRMethod "QRY_2", "RowData", "data."
    reprows=reprows+1
    table.reprows.TEKSTFELT = data.1
    table.reprows.TALLFLT1 = data.2
    table.reprows.TALLFLT2 = data.3

ok = VRMethod( "QRY_2", "MoveNext" )
end

table.0=reprows

DO i=1 TO table.0

END i

hwnd = VRGet( "Window1", "HWnd" )

rc=VpPrintReport(hwnd, 'REP_HBAKKM.vpt', 'table.', '<PREVIEW>' )

call QRY_2_Fini

return

Attached is the resulting report which would be fine if the column now showing data.3 would show the cumulative instead.

14
Programming / Re: Rexx cumulative values
« on: May 15, 2023, 01:35:53 pm »
Thank you both.

Alex, I got this when running your code:
 *** Error 41 Bad aritmetic conversion

Lars, works fine.

Initially I had the idea that the container should display these cumulative values but there is actually no point in that.
Will use the code to create some accounting reports which also can be printed to screen.

15
Programming / Re: Rexx cumulative values
« on: May 15, 2023, 11:20:43 am »
Thanks Mentore, I have already tried with SQL and I think that's the best way. I've been trying various SQL statements that I have found on the net with DBExpert but so far no success. DBE does not come with any documentation of valid SQL-statements and I haven't found any online manual either. However, even if I could make it work with DBE I probably will have trouble making it work with VX-Rexx.

Pages: [1] 2 3 ... 16