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 - Ken Sproul

Pages: [1] 2 3 ... 5
Off Topic / Re: Direxions 2024?
« on: June 19, 2024, 04:55:12 PM »

I forwarded the email to you.
Hope to see you there!

ODBC / Re: ODBC with latest MS Excel
« on: May 09, 2024, 01:06:50 AM »

I just applied the latest updates to Office 365.
My Excel is now showing: Version 2404 (Build 17531.20140 Click-to-Run)

On the Data ribbon the section Get & Transform Data still exists with a Get Data drop-down that contains:
  • From File
  • From Database
  • From Azure
  • From Power Platform
  • From Other Sources
  • Combine Queries
  • Launch Power Query Editor...
  • Data Source Settings...
  • Query Options

Under "From Other Sources" is "From ODBC" among a bunch of other options.

What Version do you have?

Language / Re: Maximum Number of Columns in a Report View List Box
« on: February 14, 2024, 02:00:05 AM »
Thanks Mike! That was the issue.
I added logic to calculate the total standard column widths in pixels and scale them down by percentage when the total exceeded 32767.

Language / Maximum Number of Columns in a Report View List Box
« on: February 11, 2024, 07:38:07 AM »
There seems to be a limit to the number of columns a report view list box can have but I couldn't find any documentation for the limit.

I defined a list box with 267 columns. The first column is defined as S0 (not visible).
While scrolling to the right, the headings stopped scrolling at the 180th visible column.
However, the data for the remaining columns continued to scroll and display.

Is this a limit or a bug?
Is it pxplus or Windows?

Attached is a txt file containing the string used in the fmt= option.

Programming / Re: SMS Provider
« on: October 19, 2023, 03:15:52 PM »
Hi Chris,

I created an interface in our custom notification system to Clickatell ([size=78%]Clickatell.com[/size]). It was easy to do and worked as expected. You'll have to determine whether it's a good deal or not.

Language / Re: How to pass a com object string property greater than 32k?
« on: September 22, 2023, 01:24:49 AM »

That's exactly what I needed!
It seems that setting more than 32k is not an issue for some reason.

Thank you!

In case it helps someone, below is the code I used:
if len(html_value$)=32000 then while html'pvxextdata; html_value$+=html'pvxextdata$; wend

Language / How to pass a com object string property greater than 32k?
« on: September 21, 2023, 06:52:21 PM »
I'm using a com object with a string property that I need to pass a value greater than 32k back and forth.
I think there's a trick to this if memory serves, but I couldn't find it.

Programming / Re: need to skip the passworded programs
« on: August 18, 2023, 01:43:54 PM »

Got this info from program *udv:

open input (hfn,isz=512)"program"; read record (lfo)r$; close(lfo)
if and(r$(90,1),$01$)=$01$ then passworded=1

Programming / Re: Accessing a Control on Another Dialog
« on: August 09, 2023, 06:36:14 PM »
Are you doing a 'goto'(the_window_with_the_control), before trying to access the control?

To my knowledge there is no way to increase the key size of a direct file.

Programming / Re: Syntax error in IF with string expressions
« on: March 13, 2023, 08:47:49 AM »
Should have included these in my previous reply.

To do "a$ or b$":

if a$+b$ then ...

To do "a$ and b$":
if a$ then if b$ then ...

Hi James,

The "test" I'm referring to is with a "let" statement, I just omitted the "let":
let x$=a$ and 1

Programming / Re: Syntax error in IF with string expressions
« on: March 13, 2023, 08:32:56 AM »
Hi Stephane,

I found that the "if string$ " syntax only works when the result of the expression is a string. The manual could be clearer with examples, but it says the if statement can have either numeric or string expressions.  It doesn't say that it cannot have both, but that is implied.  We have to think of and's and or's as part of a numeric expression because they result in a Boolean value, which ultimately is numeric.

The way to test this is whether the expression can be used in a let statement with either a string or numeric variable.
These don't work because they mix strings and numerics:
x$=a$ and 1
x=a$ and 1
These work because they don't mix variable types:
x=not(nul(a$)) and 1
x=not(nul(a$)) and not(nul(b$))

Hope it makes more sense now.

Web Services / Re: *web/email question regarding running in background
« on: March 03, 2023, 04:02:27 PM »
Thanks for the info Mike.

I was wondering if it was doing some kind of UI waiting forever for a user response since we had to kill and restart the process to get it going again.  We did however get an authentication error when we tested sending an email in a foreground process, which is how we figured it out.

Web Services / *web/email question regarding running in background
« on: March 02, 2023, 06:27:04 PM »
This may be for the PxPlus team.

We have a background process that sends emails using *web/email.
This process is designed to handle any email errors reported by *web/email and continue running.
Recently that background process started hanging.
We discovered that that the email server credentials had changed.
Once we updated the credentials, the process stopped hanging.

So my question is what could be happening inside *web/email to cause the background process to hang instead of simply returning the authentication error?

PxPlus Version: 15.10

Thank you to all who replied.

I have the same need to know for *cmd programs which also can be entered at a command prompt or called using code in a program.

What I would like to know is how the program was initiated, either entered at a command prompt or called/performed in a program, regardless of the procedures and arguments that may be involved.

Wish: Maybe a new tcb() flag could be established to indicate this. :)

Pages: [1] 2 3 ... 5