I tried importing the external definition for one of the tables. There were 6 fields with invalid characters (%:/), so they didn't get defined in the PxPlus DD. I manually defined them, as I only really need them as placeholders. But now, when trying to open the file with the link, I get Error #84: No DICTIONARY exists on OPENed file, and the query won't get there either. I don't want to try writing the iolist out, since it's an external DB file, and there are lots of other downstream apps and reports that I'm sure expect things the way they are.

Any other possibilities? 

I have an ODBC file linked as the primary source for a Query. Using a field from that file, I want to retrieve data from a PxPlus file on our server. I don't see how PxPlus will let me do this. It seems that once the primary is set as external, it expects all files to be in the same external Database; no "mix-and-match" capabilities.

Did I miss something?

Check for trailing spaces. Also font size may tie into resolution.

Any insights?

That explains it...

Thanks!

Is there any known limit on the number of pseudo-properties that can be included in a single statement? I'm getting syntax errors when I start getting close to 30.

We only ran into this recently, and only when doing an "Update File" from the DD F/M. The data and key structure has been around for YEARS, and we've done the manual padding to deal with it.

We'll probably just note that any such updates to this or similarly-constructed files will need some special attention.

Thanks for checking into it.

It's with a DD update. We updated a definition, which has an external-only single-field key, which required a copy-update. Post-update, the keys had been stripped. We wound up building a quick program to run through and re-write the records with padded keys while removing the incorrectly-keyed records.

We have a grid with a column defined as a VarDropBox. Each cell in the column has the 'Text$ defining the list of entries, and each cell can have a different list. The column also has a validation logic attached to the cells.
Processing through the panel will set up various fields and load existing data into the grid.
If I click from outside the grid into one of these cells and choose an entry different from the original value, the validator is provided a null value for the Old_Value$, which should actually contain the previous cell entry, from my understanding.
If I click into a different row in the same column, the Old_Value$ reflects the value from the previous cell, not the currently selected cell, as I believe it should.
Also, returning an error message does not restore the cell's contents to the previous value; it retains the (incorrect) updated selection.
Am I missing something?

So there's no real way to prevent it from being stripped in a file update that will leave both the key and data intact before/during/after reading/writing.

The thing, though, is that we don't want is stripped at all. We already do all the processing on it to keep it padded in our application and for downstream apps.

Neither. See attached.

Some of our files are still using external keys. During F/M, the key value may not fill the field, so we are manually padding it to the full length.

With a Data Dictionary definition for the file set up having all discrete Delimited fields, the external key field is specified. If we need to update the file, however, the key value is stripped of trailing spaces in the updated file, even though the data field still retains them.

Is there any way to prevent this?

We recently upgraded from v15.1 to v22.1 (yay!) with very few tweaks. Looking good and working well!

I'm working with the new Data Dictionary grid interface. It looks great, but seems to drag, at best. After entering a field name and pressing Enter or Tab, the next cell is highlighted, then it reverts back to the Field Name entry - usually. Sometimes it works properly. Sometimes it is just stuck in that cycle. Very frustrating, to say the least (I've almost broken my keyboard!).

Am I missing something? Is there something that's not set correctly?

It may not be listed as "EZWeb Server" but it's probably the item 6 up from the bottom of the list: Web Server.