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 ... 9 10 [11] 12 13 ... 17
151
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

152
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!

153
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.
 

154
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)

155
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).

156
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.


157
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

158
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.

159
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?

160
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.

161
Programming / Re: Vx-rexx container
« on: December 12, 2016, 12:50:58 pm »
Good help from LesK (comp.lang.rexx) solved the problem;

sum = 0

and adding in the loop

parse var data.7
sum = sum + data.7

results in correct output.

162
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
    end
    say str
    ok = VRMethod( "QRY_AVR", "MoveNext" )
end

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.

163
Applications / Re: OpenOffice and email
« on: November 14, 2016, 06:30:06 pm »
Thanks Dave,  I didn't have the "Internet Application Integration" installed on this system, but I should of course have thought
about the ini-file settings.

164
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?

165
Marketplace / Re: VisPro/REXX Data Entry Object Pack
« on: September 26, 2016, 02:20:32 pm »
Still very much interested, pm sent.

Pages: 1 ... 9 10 [11] 12 13 ... 17