James - it is so funny you said that. I did something like this in our billing software (and i forgot about that). the one difference here is that our user wants it to honor their seps/line breaks. I did not do that in the billing software. I might use this as a last resort. Thank you. but i think you are confirming my thought that there is not a really easy way.

right now what i'm doing is using a mixture of : a fixed font , and controlling the width of the control and that seems to be doing it but i'm not sure if it will work with all monitors.

We have descriptions that print in 30 character blocks.
is there a way on a multi-line (that has a height > 1 / i.e. multiple lines)
that i can control it so that if they type 30 characters on a line that it rolls to the next line.
i'm open to any solution.

Hi Devon,

both the 16.2 and the 19.1 are querying
      the same SQL database
      using the same dsn
      on the same server


We are in the process of upgrading there pxplus software
the only thing that i can see that has changed is their pxplus version.

do you think i should open a ticket with pxplus?

Hello,

We have a client that is migrating from pxplus 16.20 to 19.10.
We have a Pxplus write record of a native sql command that reads from an Infor SQL Database.
In 16.20 it works but in 19.10 i get this error

HY000: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt

the command is just a "SELECT *" statement.

does anyone have any thoughts/insights.

jeff

I have a client using odbc client/server 5.20 - they migrated their app to a 64 bit version. On 2 files they are getting the following error:

Exception from HRESULT: 0xC0014020
Error at Purchasing Ledger Summary [ODBC Source [123]]: SQLSTATE: S0000, Message: [PxPlus][ODBC Driver][PXPIO]File does not exist;

they can query every other file fine. The file seems to be in the .ddf - has anyone ever seen anything like this?
thanks
jeff

Hi Deven

Windows Server 2016
when i use excel to try and file that is when i get the error.
you know in msquery when you can slide fields from left to right.

jeff

I have a catalog.
If I just use The Data Dictionary - it works fine
If I just use the INI File - it works fine
If i use the Data Dictionary and INI File - it throws error on ini file files-> No Data Dictionary

can this be done?

Deven the html image link worked. i had to change the control size but it still looks good. thank you

Hi All,

I'm working on a program to display Delivery Pictures for a customer. I'm displaying the pics using Shell.Explorer. It is working nice except the pictures are really large. I found if I do a ctrl + scroll zoom in and zoom out. Is there a way i can do this with negative ctl's?

or maybe there is a way to fit the picture to the screen. We used shell explorer because it gives a preview of multiple docs (xml, pdf, any image, text)

thanks

jeff

Hi Deven, my field contains hexadecimal characters and i think that is causing problem.  than you for clarifying for me.

thank you Deven - so it doesn't seem to be working for me.
i'll try again ...thank you.

I would consider Offset to be where we start in string like in a mid function
let if string is
JEFFREY-JONES
Offset = 4
Length = 3
and i say offset is 4 (assuming 0 based then) i would expect it to return
"REY"
where the "R" is in the 4th position (0 based) and then go over 3 characters...
is that what the Offset is?

I'm struggling with something that works but I don't understand why?

[*tables*]
Unit_Completion=p:\custom_data\CFUNIT
[Unit_Completion]
ORDER_NUMBER=STRING,LEN=9,FIELD=1,OFFSET=6
UTC_MTIME=STRING,LEN=10,FIELD=2,OFFSET=0

Can someone tell me what ORDER_NUMBER=STRING,LEN=9,FIELD=1,OFFSET=6 what this is doing?
it does what i want but intuitively i feel like it should not be working.

Hi Mike - thank you. this worked for me.

thank you Mike - i will give it a try.