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

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

3
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'

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

5
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$'.

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

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

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

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

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

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

12
iNomads / Re: %inomads'upload_file() times out
« on: July 08, 2022, 09:46:01 AM »
You need to set parameter IZ (SET_PARAM 'IZ'=1) in the PxPlus session that is running the EzWeb Server or else it will run out of memory (error 31) and terminate.

13
Nomads / Re: not a graphical device -- can not use nomads panels
« on: April 28, 2022, 03:16:52 AM »
When you get that message during a PROCESS, the message comes from the GET_VERSIONS routine in *WINPROC:

14320 LET _X$=MSE
14325 IF MID(_X$,1,1)=$FF$ THEN PRINT "Not a graphical device -- cannot use Nomads panels"; EXIT

Can you enter these commands in PxPlus console mode and show us the output:

PRINT CVS(FIN(0),16)
PRINT HTA(MSE)

14
Nomads / Re: not a graphical device -- can not use nomads panels
« on: April 27, 2022, 04:42:24 AM »
That message comes from *Nomads:

->load"*nomads
->list 26
0026 IF TCB(88)=0 AND TCB(82)<0 THEN PRINT "Not a graphical device -- cannot use Nomads"; END

So if you're not using WindX (tcb(88)=0) and your OS isn't Windows (tcb(82)<0), you're not allowed to run a Nomads application.

15
iNomads / Re: Calendar Objects in iNomads
« on: March 10, 2022, 04:47:17 AM »
I think the trick is to create a 'Calendar Control Definition' that doesn't use any separation characters, like 'YYYYMMDD' or 'MMDDYYYY' (instead of 'YYYY/MM/DD' and 'MM/DD/YYYY').

In the multiline that receives the date, you want to use an 'Input Mask' with separation characters (0000/00/00 or 00/00/0000 in my examples).

And the 'Initial Value' should be a true date, for example Expression DTE(0:"%Yl%Mz%Dz") or Expression DTE(0:"%Mz%Dz%Yl") - again without any separation characters. 

I've attached an example. Import 'calendar.txt' in a Nomads library.  Create the Calendar Control Definitions (all three) like shown in the pictures (same names and properties).

Should work in v15 up to v18.

Pages: [1] 2 3 4