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.


Topics - Jeffrey Ferreira

Pages: 1 ... 3 4 [5]
61
Programming / Sort On Header Click - ** DISREGARD **
« on: August 22, 2019, 01:24:01 PM »
Hello List,
So i have a grid that takes a long time to load.
After it loads we apply filters. So I thinking I was smart instead of loading again I said i'll manipulate row height to hide filtered rows
everything works fine until they click on a Grid Header and my rows height seem to all go back to default....

Is there a way to either
a.) preserve my row heights
b.) Detect a Sort on Header Click.

i see what is happening
the hidden rows are now being sorted into the positions where the row height is visible and vice versa.

62
Language / save control 0
« on: August 20, 2019, 04:16:47 PM »
Hello List,
we have always used the "save control 0" command as a print screen utility within our language. It takes an image of the active window and then we print it out. This worked fine for a long time.  But not on certain users screens instead of taking a snapshot of active window it is taking a snapshot of top left hand corner of screen.

Has anyone had any issues like this?
thanks in advance
jeff

Here is our environment:

- Windows 2016 (just switched to this)
- Terminal Services
- PxPlus 14.10 (just switched to this)


63
Language / *plus\web\request
« on: August 08, 2019, 04:28:47 PM »
Hello,

i've been using *plus\web\request a lot but periodically (once  a day)
i get an error 47 at line 100

recvhdr$=stp(r$(1,o-1),3,$0D$)+$0A$

my first thought is to put an error branch on call and then re-try it...

but has anyone else experienced this error and maybe know a fix

jeff

64
Programming / *web\request
« on: July 31, 2019, 01:07:44 PM »
Hello List,

I'm using *web\request to communicate with a web\service. I'm quite new to the whole posting to a web service....
I'm having trouble with one of the POST's.

Someone has shown me a tool call post-man to show me what the code looks like in other languages  (like python, node, javascript, etc)
and all of them do this thing where they wrap the POST_BODY in this webkitformboundary

my post fails...
i'm just curious...do i have to do this webkitformboundary or does *web\request do this for me...

payload = "------WebKitFormBoundary7MA4YWxkTrZu0gW\r\nContent-Disposition: form-data; name=\"filename\"; filename=\"DiscountUpdate.xml\"\r\nContent-Type: application/xml\r\n\r\n\r\n------WebKitFormBoundary7MA4YWxkTrZu0gW--"

headers = {
    'content-type': "multipart/form-data; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW",
    'Content-Type': "application/x-www-form-urlencoded",

65
Language / Parameter '-NE'
« on: July 08, 2019, 01:27:58 PM »
Hello List,

I have parameter '-NE' set because I'm running a program as a scheduled task and I want the errors returned to the performing program.  I was wondering is there any variable I could access to get more info about the error that happened in the "Performed" Program.

thanks

Jeff

66
ODBC / Providex File Service Keeps Dying
« on: July 02, 2019, 09:21:02 AM »
Hello List,
We have this account where we are running Providex File Service and PxPlus IO Service.
the PxPlus IO Service runs fine.
but everytime we go to query from the Providex File Service  the Service Stops.
The event viewer is not helpful.
I added a log to my dsn....
and here is what i get (see below)
does anyone have any thoughts

=======================================================
Driver version: 5.20.0000
ISAMOpen: UserID='cai', length=3
ISAMOpen: Trying to access the server using UserID='cai', Company=''
GetAccessibleTables:<table=ALL> Open catalog(s) [rmt:ponderosa1;20222]p:\cai\cai_lib , available 1266 table(s)
<Customer Master File> Open file p:\customer_data\mpd\MF1010, maxksz=22
ISAMCloseTable: Closing table Customer Master File - 0 file reads, 0 re-reads, 0 writes, 0 removes
     CACHE STATS - 0 reads, size 21642240 estimated, 0 used
------------------------------
SELECT * FROM "Customer Master File" WHERE 0 = 1

<Customer Master File> Open file p:\customer_data\mpd\MF1010, maxksz=22
Accessing table Customer Master File using keyno 0 * All records *
ISAMCloseTable: Closing table Customer Master File - 0 file reads, 0 re-reads, 0 writes, 0 removes
<Customer Master File> Open file p:\horner\mpd\MF1010, maxksz=22
ISAMCloseTable: Closing table Customer Master File - 0 file reads, 0 re-reads, 0 writes, 0 removes
     CACHE STATS - 0 reads, size 21642240 estimated, 0 used
GetAccessibleTables:<table=ALL> Open catalog(s) [rmt:ponderosa1;20222]p:\cai\cai_lib , available 1266 table(s)
------------------------------
SELECT * FROM "Customer Master File" WHERE ( 0 = 1 )

<Customer Master File> Open file p:\customer_data\mpd\MF1010, maxksz=22
ISAMCloseTable: Closing table Customer Master File - 0 file reads, 0 re-reads, 0 writes, 0 removes
     CACHE STATS - 0 reads, size 21642240 estimated, 0 used
------------------------------
SELECT * FROM "Customer Master File" WHERE ( 0 = 1 )

<Customer Master File> Open file p:\horner\mpd\MF1010, maxksz=22
ISAMCloseTable: Closing table Customer Master File - 0 file reads, 0 re-reads, 0 writes, 0 removes
     CACHE STATS - 0 reads, size 21642240 estimated, 0 used
------------------------------
SELECT * FROM "Customer Master File" WHERE ( 0 = 1 )

<Customer Master File> Open file p:\customer_data\mpd\MF1010, maxksz=22
ISAMCloseTable: Closing table Customer Master File - 0 file reads, 0 re-reads, 0 writes, 0 removes
     CACHE STATS - 0 reads, size 21642240 estimated, 0 used
------------------------------
SELECT * FROM "Customer Master File"

<Customer Master File> Open file p:\customer_data\mpd\MF1010, maxksz=22
Accessing table Customer Master File using keyno 0 * All records *
<Customer Master File> First Read Seek sts=0 key='', len=-1, keyno=1
<fh=Customer Master File> PVK_read returns buffer= iRsz='-1'

67
Programming / Object Oriented Question
« on: June 23, 2019, 07:19:06 PM »
Hello List,
i'm really new to oop.
I was trying to create an object using pxplus charts that would do something like the following:
chart1=new("chart")
and then i change properties to make a bar, line chart etc..then i can invoke the object from any panel presenting data....
the problem i am having is I want it to display in  a window...
i would like to equate to:

def object excel_obj="Excel.Application" and you have a visible excel that you can close....

the problem is when i draw a 'dialogue' and put my chart on it
if i close it i close my whole session....

i feel like once i get past this hurdle i can run with it....

68
ODBC / Error Log ODBC
« on: March 18, 2019, 11:36:41 AM »
Hello List,
On the Debug Tab of a 64 bit odbc pxplus data source i checked.
Enable Debug
and then specified log file
if i use test connection it outputs to the file but no other tests will write to the file....Excel  or Other applications that we use to access it...
Has anyone had this issue before....
i have used this feature before at another client with some degree of success.

jeff

69
Programming / Generic Query
« on: March 07, 2019, 04:35:30 PM »
Hello List,

I tend to always run into these one off situations where I need user input from a list
but the data is not in a file and too many selections for a message box.
and i dislike making a panel for each instance....
so i had this idea for a generic query routine that i could
pass in an associative array
and get a return value
============================================
here is my code ...it is almost working but i dont think i have the OBTAIN right
and the arrows are not working on the list box.....
has anyone ever done this?
can someone help me out

29000 !
29010 GENERIC_QUERY:
29020 enter (PANEL_TITLE$),ARRAY${all},RETURN_VALUE$
29030 if dim(read num(ARRAY$))=0 then exit ! If No Values then Exit
29040 call "CAIREPOS;PRINT_CENTERED_DIALOGUE",50,35,(PANEL_TITLE$) ! This is just my routine to Print a Centered Window (this part works)
29050 let LOAD_THIS$=""
29060 for ARRAY_INDEX$ index ARRAY${all}
29070 let LOAD_THIS$+=ARRAY_INDEX$+sep
29080 next
29090 list_box 100,@(1,1,48,33),fnt="*"
29100 list_box load 100,LOAD_THIS$
29120 list_box write 100,1,err=*next
29121 let NEXT_ID=100
29130 wait .5
29140 repeat
29150 obtain (tim=2)NIU$
29160 let MODE$=""
29170 list_box read 100,RETURN_VALUE$,MODE$,err=*next
29180 until MODE$=$0D$ or MODE$=$02$
29190 print (0,err=*next)'pop',
29990 exit

70
Programming / JSON to Array
« on: February 28, 2019, 10:58:38 AM »
Hi All,

I know we can take a PxPlus Associative Array and convert it to JSON.
I'm struggling with the inverse.
How do I parse JSON passed back via PxPlus.
Is it possible using PxPlus?

jeff

71
Programming / Defining Function
« on: February 25, 2019, 11:51:13 AM »
Hello List,

I'm trying to avoid using a global function but I would like function available in multiple programs.  I tried doing the following: 

PROG01

10 perform "PR0G02;DEFINE_FUNCTIONS"
20 PRINT fnPAIR$("Key","Value")

but I can't access the function defined in PR0G02

is my only recourse  a Global Function?

jeff

72
Programming / Multi Line Dash
« on: February 21, 2019, 11:22:19 AM »
Hello
 
I have a multi line that contains a description that contains dimensions as follows:

Blue Widget 35-7/8x79-3/8

what happens in the multi-line is that it sees the dash as an allowable place to split up a word
so it will do something like this:
===============
Blue Widget 35-
7/8x79-3/8
===============
if i change the - to anything else it seems to keep it together...
do i have any way around this aside from changing the dash to something else?

jeff


73
Programming / pxplus/web/request curl -k
« on: February 19, 2019, 04:37:20 PM »
Hello
i'm trying to use pxplus web request.
my code wasnt working 403 Forbidden.
to test my code i used curl and to get it to work i had to use the -k flag
is there any equivalent to this curl -k that i can use in pxplus web request
or should i just use curl
thanks

jeff

74
ODBC / Extract on ODBC Sql Server
« on: August 22, 2018, 02:45:52 PM »
I was opening up a MS SQL Server table with [ODB].
Out of habit I tried to do an extract before writing a record and I received the following error:
msg(-1) = for update clause allowed only for declare cursor.
Does anyone have any idea what this is?
I ended up just doing a read/write and that worked.
Should I not bother with EXTRACTS on [ODB]SQL

75
Language / text/html encoding is coming thru as attachment
« on: July 13, 2018, 11:46:00 AM »
I use the *web\email encoding all the time.
I'm working on a client using pxplus 10.2
and when i do a text/html encoding and i create the body of email as standard html it keeps coming thru as an attchment

it happens when i send to my gmail and outlook.
does anyone have any ideas?

thanks

jeff

Pages: 1 ... 3 4 [5]