Chris,


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

Mike,


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?

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.

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.

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.

Stéphane,


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:
get_html_value:
html_value$=html'value$
if len(html_value$)=32000 then while html'pvxextdata; html_value$+=html'pvxextdata$; wend
return

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.

Jim,


Got this info from program *udv:


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

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.

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

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$=a$
x=not(nul(a$)) and 1
x=not(nul(a$)) and not(nul(b$))


Hope it makes more sense now.

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.

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.