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 [4] 5 6 ... 11
46
Internet / Re: Couldn't resolve host
« on: May 06, 2018, 02:49:00 pm »
This is the result of tracerte:

traceroute to mail.broadpark.no (80.235.81.36), 30 hops max, 38 byte packets
1 10.0.0.1            (10.0.0.1) 0 ms 0 ms 0 ms   
2 * * *
3 * * *
4 * * *
5 * * *
6 * * *
7 * * *

I believe that the user of this pc has accidentally changed something. To change MTU size, isn't that done
via command prompt? Doubt that this user has changed anything that is not easily changed from the WPS.


47
Internet / Couldn't resolve host
« on: May 05, 2018, 03:44:36 pm »
Hi,

I have a rexx program that automates sending emails with attachments and it has worked perfectly for years.
All of a sudden it is not sending anymore and I found this error message in the log:
cURL error: 6 - Couldn't resolve host 'mail.broadpark.no'

This pc is set up using DNS and and Firefox works OK.

The one who normally uses this pc cannot remember changing anything.
Nothing has changed at the ISP and all login/host details are correct in the setup of the rexx program.

Ideas anyone?

48
Applications / Re: CUPS - Support Printer List
« on: January 04, 2018, 08:39:11 pm »
I chose HP Color LaserJet 3700 PS for my HP M477dfw, prints fine, and duplex works.
When you create the printer object just choose to install driver shipped with ArcaOS/eCS and you will get a list of printers.
In my case the HP 3700 PS works fine, but you may have to try another PS for your printer.

If you have a ppd-file for the printer you could also import it.
You can find some good info/tools at http://www.altsan.org/os2/printing/


49
Applications / Re: CUPS - Support Printer List
« on: December 19, 2017, 08:43:00 pm »
HP Color Laser Jet Pro M477fdw works with a pscript driver supplied with ArcaOS/eCS.
(For scanning, I either scan to e-mail or to a networkfolder).

50
Setup & Installation / Re: Printer advice.
« on: November 26, 2017, 12:16:34 am »
I set up newer HP-lasers to use SLPR and one of the PS3 drivers supplied with eCS/AOS.
(Haven't had the need to try Cups yet.)
No experience with Brother but it seems to support PostScript3.

51
Applications / Re: DBEXPERT crash with thunderbird open and firefox
« on: November 14, 2017, 05:19:11 pm »
Hi Roberto,

Double cliking the dbe-file results in a crash while opening it from DBE works.
Something seems to be wrong with the form FMENU2, it won't open in design mode.

The form TEST works and the button "CRASH?" sometimes brings up the form "Libros a prelegalizar" and sometimes it crashes.
(No difference if Firefox or Seamonkey is running or not.)

Per

52
Programming / Re: SQL/DBExpert
« on: October 25, 2017, 09:08:06 pm »
Created a new app and it now works. (Didn't have to reinstall DBE.)

Thanks a lot!

53
Programming / Re: SQL/DBExpert
« on: October 25, 2017, 08:40:07 pm »
For testing purposes I created tables/fields/values to be used with your code. When/if I get it to work I will of course
do the necessary adjustments. Somehow I now get the macro to run without an error but it does not insert the values to the table.
Makes me wonder if the crashes I had has caused some unwanted changes somewhere, think I'll reinstall DBE and make a new app.
 

54
Programming / Re: SQL/DBExpert
« on: October 25, 2017, 05:40:24 pm »
I created the tables and used exactly the same code as you posted, (copy&paste).

CAD='INSERT INTO TPSUFORPRINT (LOSVAL,ACT3, ACT1, CL10, ORDEN, ACL5) SELECT',
   '  '"'"LOSVALCAL"'"' AS VAL7, '"'"ACT3R"'"' AS VAL1, '"'"ACT1R"'"' AS VAL2, '"'"ACT3R"'"' AS VAL3, 1 AS VAL4, '"'"ACT1R"'"' AS VAL5 FROM CATALIZA'
RC=DBERUNSQL(CAD)

55
Programming / Re: SQL/DBExpert
« on: October 25, 2017, 04:15:43 pm »
The sum I get from a form so I'm not sure what you mean with the first example.

DBE crashes when running the second example, although when running it as "Single step" all seems fine until it actually runs RC=DBERUNSQL(CAD).

56
Programming / Re: SQL/DBExpert
« on: October 25, 2017, 03:02:31 am »
I'm trying to create a new row/record.
(For updating I use the command UPDATE which works fine from a macro.)

Already tried and it does not work

dbeRunSQL(INSERT INTO TABLENAME(TABLEFIELD) SUM)

Also tested with 'VALUES' expression.


57
Programming / SQL/DBExpert
« on: October 24, 2017, 10:09:17 pm »
Hi,

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

Trying to achieve this:

SUM = 10000
dbeRunSQL(INSERT INTO TABLENAME(TABLEFIELD)) SUM

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;
INSERT INTO TABLEA(FIELDA) SELECT TABLEB.FIELDB FROM TABLEB

Ideas welcome,
Per

58
Setup & Installation / Re: Ghostscript error
« on: May 25, 2017, 04:50:40 pm »
Thanks, Andy, that was the case. A new version of gsdll2.dll had been installed in x:\usr\lib and after renaming that one PMPDF works fine.

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

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?

60
Setup & Installation / Re: ArcaOS installation
« on: May 23, 2017, 02:24:25 pm »
Yes, you'll find "ArcaOS50_InstallationGuide.pdf" in the root of the installation dvd.

Pages: 1 2 3 [4] 5 6 ... 11