PxPlus User Forum

Twitter Twitter Twitter

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 - EVa

Pages: [1] 2 3 4
1
Programming / Re: accessing mySQL-DB
« on: March 26, 2024, 05:08:25 AM »
A temporary work-around is to downgrade the mariadb3 package to version 3.1.13-3.30.1 - the PxPlus MYSQL interface works correctly with that version.

2
Programming / Re: accessing mySQL-DB
« on: March 26, 2024, 04:54:28 AM »
PvxPlus Technologies is looking into this.

3
Programming / Re: accessing mySQL-DB
« on: March 14, 2024, 04:53:23 AM »
Can you tell me the Linux version that you are using (I assume it's the 64-bit version of both the OS and PxPlus) ?

4
Programming / Re: accessing mySQL-DB
« on: March 13, 2024, 11:57:13 AM »
I'm running CentOS8, my MariaDB library version is:

libmariadb.so.3-3.1.11-2.el8_3.x86_64

Your program codes works without an error in v20.10 (64-bit).

5
ODBC / Re: UPdtae table send me message column not found
« on: February 29, 2024, 05:44:45 AM »
I can't help you with that - you need to contact whoever created the file/dictionary entry as it looks like these do not match.

6
ODBC / Re: UPdtae table send me message column not found
« on: February 28, 2024, 03:20:45 AM »
Doesn't happen here, but I don't have your dictionary information.  When my table has this data:

1:dump
ADDRESSLINE1$="addressline #1"
ADDRESSLINE2$="addressline #2"
ADDRESSLINE3$="addressline #3"
CITY$="City"
COUNTRYCODE$="USA"
CUSTOMERNAME$="Customer CMS00"
CUSTOMERNUMBER$="CMS"
DIVISION$="00"
STATE$="NY"

and I execute this update:  UPDATE AR1_CustomerMaster SET CustomerName='California Metal Services Inc ' ,AddressLine1= '1428 W Mission Road ',AddressLine2= '1430 ',AddressLine3= ' ',City='ESCONDIDO ' ,State= 'CA ' ,CountryCode= 'SA ' where   Division='00' and CustomerNumber='CMS'

the table then has this data:

1:dump
ADDRESSLINE1$="1428 W Mission Road "
ADDRESSLINE2$="1430 "
ADDRESSLINE3$=" "
CITY$="ESCONDIDO "
COUNTRYCODE$="SA "
CUSTOMERNAME$="California Metal Services Inc "
CUSTOMERNUMBER$="CMS"
DIVISION$="00"
STATE$="CA "

which is correct.  If this doesn't work for you, I would suspect that the dictionary information isn't correct.

7
ODBC / Re: UPdtae table send me message column not found
« on: February 27, 2024, 04:15:08 AM »
It works here when I replace " with ' :

UPDATE  AR1_CustomerMaster  SET  CustomerName='California Metal Services Inc ' ,AddressLine1= '1428 W Mission Road ',AddressLine2= '1430 ',AddressLine3= ' ',City= 'ESCONDIDO ' ,State= 'CA ' ,CountryCode= 'SA ' where   Division='00' and CustomerNumber='CMS'

8
ODBC / Re: Serius I complete missing undesrtand odbc
« on: February 21, 2024, 03:06:40 AM »
For starters, you could enable debugging to see if there's a difference the 1st and 2nd time you connect.  Also, this appears to be a rather old version of the ODBC driver as it says 'ProvideX' in the title bar ?

9
Programming / Re: Error 114 recovery
« on: January 17, 2024, 03:12:04 AM »
If an open fails, you will need to open the file in binary mode, for example:

open input(1,isz=1)"filename"

Then use read record(1,siz=size)d$ to read the binary contents (size needs to be a multiple of 256 and a file has a file header, key blocks, inventory blocks, data blocks, etc).  Assuming you know what the data looks like, you can then search 'd$'.

10
Programming / Re: temporary error 11
« on: November 29, 2023, 04:44:16 AM »
Can you show us the FIN(file,"FILE_CREATE") for that file ?

11
Programming / Re: Menu Bar Height and Font
« on: August 31, 2023, 03:46:29 AM »
AFAIK, the menu appearance is a global (Windows) setting.  You used to be able to change the menu font size in the Control Panel, under Appearance and Personalization, Display, but they have removed that item (Display) in more recent Windows versions.  There's a 'System Font Size Changer' tool that still allows you to change the menu size though.

12
Doesn't this work:

0025 LET SOMETHING=(NUM(MID(STK(-1),1,5))=0)

If I'm not mistaken, the line number of the caller when in console mode is '0'.  If you're in a program, it's the actual linenumber of that program.

13
Programming / Re: Transform pdf to base 64
« on: August 24, 2022, 04:15:08 AM »
I can't reproduce this - here's what I did:

PxPlus-2019 Web (Ver:16.10/UNIX-Linux-RedHat) Serno:1610-664-0xxxxxx
(c) Copyright 2005-2018 PVX Plus Technologies Ltd. (All rights reserved)
  Website: http://www.pvxplus.com
->010 BEGIN
-:0020 LET BASE64_FILE$="/tmp/50_09790301_13_200_002_led_kalender.base64"
-:0030 LET PDFFIL$="/tmp/50_09790301_13_200_002_led_kalender.pdf"
-:0040 OPEN (1)"*PDF*;FILE="+PDFFIL$+";OVERWRITE"; LIST (1); CLOSE (1)
-:0050 ERASE BASE64_FILE$,ERR=*NEXT                                   
-:0060 CALL "*web/base64;ENCODE_FILE",PDFFIL$,BASE64_FILE$           
-:run                                                                 .                     
-:open input(1)base64_file$;print rcd(1)
JVBERi0xLjMKJbe+raoKMSAwIG9iago8PAovVHlwZSAvQ2F0YWxvZwovUGFnZXMgMiAwIFIKPj4KZW5kb2JqCjIgMCBvYmoKPDwKL1R5cGUgL1BhZ2VzCi9LaWRzIFsgNSAwIFIgXQovQ291bnQgMQo+PgplbmRvYmoKMyAwIG9iago8PAovUHJvZHVjZXIgKHd3dy5wdnhwbHVzLmNvbSkKL0F1dGhvciAocm9vdCkKL0NyZWF0b3IgKFB4UGx1cy0xNi4xMC4wMDAwKQovVGl0bGUgKFVudGl0bGVkKQovU3ViamVjdCAoTm8gU3ViamVjdCkKL0tleXdvcmRzIChub25lKQovQ3JlYXRpb25EYXRlIChEOjIwMjIwODI0
-:

I open the base64 file in gedit, copy the contents and paste them on that website.  The result is the attached picture (the correct PDF contents).

14
Web Services / Re: Setup EZWeb server on RedHat Linux 8.x Server
« on: August 16, 2022, 02:54:20 AM »
And what does line 160 of program ltstulip.pxp look like ?

15
Nomads / Re: cell editing
« on: July 28, 2022, 06:34:15 AM »
Is this close enough:

0010 BEGIN ; PRINT 'MODE'($000F$),'CS',
0020 PRINT 'OPTION'("GridMLVersion","0"),
0030 LET G=10; GRID G,@(38,1,40,8)
0040 LET G'COLUMNSWIDE=4,G'ROWSHIGH=5,G'ENTERMODE=2
0050 LET G'COLUMN=0,G'ROW=0,G'COLUMNWIDTH=8,G'CELLTYPE$="Multi_line"
0060 FOR R=1 TO 5; FOR C=1 TO 4; LET G'COLUMN=C,G'ROW=R
0070 LET G'VALUE$="C"+STR(C)+"/R"+STR(R); IF R/C=1 THEN LET G'LOCK=1
0080 NEXT ; NEXT ; LET G'CURRENTCOLUMN=2,G'ROW=1; SET_FOCUS G
0090 WAIT:OBTAIN *; IF CTL=4 THEN STOP
0100 GOTO WAIT

<enter> stops editing the cell, and the next <enter> moves focus to the next cell.

Pages: [1] 2 3 4