Hi Devon,

What I meant was this:
I have a file with an extended record size up to 2gb.
I want to create an alternate key that consists of field #25 with a length of 10 that is physically located somewhere near the end of the record, say 1.5gb ([25:1:10]).
Will the data for the key be found there, or does it have to be physically located within the first X number of bytes in the record?

I know there's a requirement for where the data for key segments must be found in an extended record file. In other words, a key segment will not find the referenced data beyond a certain number of bytes in the record. I need to know what that number is. I think it might be 31000, but I couldn't find it in the documentation.

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.