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.

Topics - Per E. Johannessen

Pages: 1 2 [3] 4
Programming / SQL/DBExpert
« on: October 24, 2017, 10:09:17 pm »

Anyone who knows how to use "INSERT INTO" in a DBExpert macro?

Trying to achieve this:

SUM = 10000

The SUM I actually get from a form and I need the macro to run from this form.

(I've tried moving/adding/deleting " ( ",  " ) ", TOTAL and " ' " in all the positions I can think of but no success.)

Running INSERT in the query designer works, but there it gets the value to insert from a table like;

Ideas welcome,

Setup & Installation / Ghostscript error
« on: May 25, 2017, 01:08:03 am »

I have for years used PMPDF and GhostScript 9.04 (or earlier versions) and setting it up on various eCS system without any problems.
Now I just tried to make it work under ArcaOS, installing the same way as before, but get this error when trying to create a pdf:

Error in GhostScript processing, code:255 -

(I've not installed using yum/rpm and I have not set up any ecups on this system.)

Anyone else experienced this?

Programming / Vx-rexx container
« on: December 11, 2016, 09:14:29 pm »
I have a container object with several columns and I need to sum the values of one column for displaying the sum in
a field outside the container, each time a record is entered.

ok = VRMethod( "QRY_AVR", "MoveFirst" )
do while( ok = 1 )
    call VRMethod "QRY_AVR", "RowData", "data."
    str = ""
    do i = 1 to data.0
        str = str data.i
    say str
    ok = VRMethod( "QRY_AVR", "MoveNext" )

With 2 records the output of say is (from data.1 incl. data.7):

 555 1230 1111 TEST1 1.0  10500 35880
 555 1230 8951 TEST2 1.0  -3456 -8951

The last column, data.7, contains the numbers I need the sum of.
Now the problem is how to make the sum of data.7 and make it available for displaying in a field.

Ideas are welcome and appreciated.

Applications / OpenOffice and email
« on: November 14, 2016, 05:48:49 pm »
The settings for "E-mail program" in OpenOffice 4.1.1 points to seamonkey.exe (which is correct) but when sending a mail it opens Thunderbird,
anyone else seen this and know the solution?

Marketplace / VisPro/REXX Data Entry Object Pack
« on: September 23, 2016, 07:07:06 pm »

Does anyone know where I can obtain/purchase a copy of VisPro/REXX Data Entry Object Pack?

General Discussion / Need some help with REXX
« on: August 30, 2016, 04:44:38 pm »

I've got some txt-files that I have to "manipulate" before importing them to a database, simple enough
for someone who knows REXX, but unfortunately I'm not (yet) one of those.
Does anyone know about a sample that reads a txt-file, does some manipulation to each line and
writes to a new txt-file? (I'm stuck with the "manipulation" part  :o )

The files are for business purposes and I can't go public with them, however, I can provide samples
if somone's interested. If so, please pm me.

Hardware / HP Color LaserJet MFP M477fdw
« on: July 27, 2016, 02:51:12 pm »
Just thought I'd inform that I got this printer to work with an old HP Color LaserJet 3700 ps-driver, incl. duplex,
using SLPR. This model seems to have lots of functions, not supported by the ps-driver, ie scanning to a network
folder. Will report more when I, hopefully, get it set up right.

Hardware / HP CLP M277n
« on: January 06, 2016, 09:42:31 am »

Is anyone using this printer with eCS/OS2?
Print languages: HP PCL 6, HP PCL 5c, HP Postscript Level 3 emulation, PCLm, PDF, URF
Sounds promising but I'd appreciate comments.


Applications / R:Base 5.5
« on: October 12, 2015, 07:08:39 pm »
Just wonder if someone has experience with R:Base 5.5 for OS/2?

Marketplace / OnCmd
« on: September 28, 2015, 10:39:16 pm »

Anyone happen to have OnCmd for OS/2 for sale?

Applications / DBExpert update multiple fields and records
« on: August 16, 2015, 03:22:41 pm »

DBExpert has a nice "query function" to update values of selected fields and records in a table but I'd like to run this procedure with a macro.
The table TRANS has many fields and records and I need to change the values of fields CPA, CPB, CPC and CPD for all the records.
Does anyone have a sample of how to do this?


Applications / Drupal, apache2 and php5
« on: June 25, 2015, 03:29:10 pm »

Apache2 and php5 seem to run fine so I thought I'd give Drupal a try. Installation works until it starts claiming about a missing directory and a couple of files and it states it cannot created them. I have verified that the directory and files do exist where they're supposed to. Believe this has to do with a conf-file or possibly php.ini, the settings in them are all new to me, and a simple google takes me to "answers" for other OS. (Which for a newbie confuses the situation even more.)
This is only a test setup on "localhost" so I wonder if any of you can tell me what to change where in order to allow Drupal full read/write access to necessary directories.


General Discussion / Business Interoperability Interfaces
« on: April 24, 2015, 08:06:46 pm »

Businesses and authorities keep implementing "EHF - Electronic Trading Format" , meaning that they can receive and send invoices/credit notes (and lots of other stuff) in a "special" format. Believe they use "some xml-format" .

Sooner or later we have to offer this to some of our clients, and possibly convert ps or pdf to the "EHF" specifications could be the solution.

Does anyone have any experience with this?


A lot of reading here:  :-\

Marketplace / VX-REXX 2.1 CS
« on: April 10, 2015, 04:15:20 am »
Does anyone know where to obtain a copy of VX-Rexx 2.1 client/server?

Utilities / unixODBC 010
« on: March 24, 2015, 07:49:48 pm »
Having some trouble with the sqlite driver that comes with unixODBC 010:
Created the sample "ex1" that comes with SQLITE- and it opens correctly with
the SQLite manager in Seamonkey.
When I use unixODBC data manger it logs on successfully but it lists:
User Tables (0)
System Tables (0)
Views (0)
Procedures (0)
and this error is in the sql.log:
DIAG [HY000] [SQLite]no such table: tb11 (1)
Any ideas why?

Pages: 1 2 [3] 4