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 - James Zukowski

Pages: [1] 2 3 ... 17
Programming / Re: REMOVE failing if record not EXTRACTed
« on: March 22, 2023, 03:54:14 PM »
Tried to re-create the problem, but couldn't. When I manually write the file and REMOVE, it's all OK. Here's the create string:

KEYED "PFILE",[1:1:4]+[2:1:8]+[3:1:5]+[4:1:5]+[5:1:5]+[6:1:2]+[7:1:2]+[8:1:2],[1:1:4]+[2:1:8]+[15:1:4]+[3:1:5]+[4:1:5]+[5:1:5]+[6:1:2]+[7:1:2]+[8:1:2],0,-1024,BSZ=8,OPT="2",SEP=$8A$

There are 14M records in the EFF file, totaling 9GB. It's been around for YEARS, and just threw this one out. I thought it might be a file structure problem, so I ran a File Utility Check on it...no problems.

Strange occurrence. If it happens again, we'll see about the helpdesk ticket.

Thanks for the consideration.

Programming / REMOVE failing if record not EXTRACTed
« on: March 21, 2023, 09:39:37 AM »
We have a multi-keyed file with 2 keys; the first has 8 components, the second has 9. When we tried to manually remove an entry, the REMOVE wouldn't work unless we EXTRACTed the record. It turns out that the primary key had a null key field element. I wouldn't think that should cause it to require an EXTRACT to be REMOVEd. (BTW, the file has almost 14M records.)
Any insights?

Programming / Re: Syntax error in IF with string expressions
« on: March 13, 2023, 08:44:14 AM »
Like with Ken, I've found that most mixing of a simple string$ with anything in a boolean-type test will generate an Error 20. What I've done is to essentially transform it all to numeric/boolean testing, like not(nul(X$)), which would work in all boolean cases.

BTW, Ken, "if X$=A$ and 1" is a viable test, as the X$=A$ yields a boolean result.

Programming / Re: Strange if then else behavior
« on: March 08, 2023, 09:36:37 AM »
Yes, it looks like it should. If you add a brace before the second IF and close it at 35, it works fine. Evidently, if you {group statements} for the THEN, it's expected for the ELSE as well.

Nomads / Synchronized Scrolling
« on: February 22, 2023, 10:18:42 AM »
Is there a way to synchronize the horizontal scrolling of 2 list_boxes? The panel isn't wide enough to display the full width of the main list, which has the detail lines. We're setting up a second list of 1 line that has the totals for certain columns in the main list. By synchronizing them, the totals will always appear below the columns they refer to.

Similarly, if the user changes a column's width, is there are way to detect that and replicate it in the other list?

Thanks in advance, all!

Nomads / Re: Resizing without Resizing
« on: February 21, 2023, 03:55:38 PM »
Looks pretty good, Mike!

The only thing is that it goes through the resize logic a second time, so it does a "double-take" when starting up.

Thanks for the idea!

Nomads / Resizing without Resizing
« on: February 21, 2023, 01:59:29 PM »
When we set up many of our panels, we set them as Resizable/Custom with the various controls anchored how we want them. Part of this is to ensure we don't have any (including a logo picture) trying to be set up beyond the edges. I've noticed that this essentially sets the minimum size of the panel based on the designed size. This only allows the user to make the panel larger, but not smaller.

Has anyone got an idea about how to set a small minimum size, but initialize the panel at a somewhat larger "default" size, which would allow the user to resize the panel larger or smaller?

Thanks, all!

Language / Re: Detecting Multi-Segment Split File
« on: February 06, 2023, 08:36:54 AM »
We're looking to segment the data by date, so the historical data doesn't need to be backed up all the time. We have existing embedded io routines that apply new data writes to other related files that are used for exporting to and updating other systems. These are defined by the base file name, not the segment's name.

Language / Re: Detecting Multi-Segment Split File
« on: February 02, 2023, 05:08:40 PM »
Thanks, but i don't know if that will help us...
Is there a way to determine if a file is a segment in a segmented file? That's what's being provided by the fin(lfa,"Filename") to our embedded io routine. We only need the base filename, not the actual segment name.

Language / Potential problem in multifile.pvc
« on: January 27, 2023, 06:08:13 PM »
While testing/preparing to use split files, I ran into a situation with an embedded io routine. In multifile.pvc, the Do_Pre_Write routine does its thing until it gets to:
Code: [Select]
if IoType=1 then write lock record (Chnl[_Found_chnl],key=_key$)_rec$ else write lock record (Chnl[_Found_chnl])_rec$
if and(_opt,64)=64 then gosub Extract_Update else extract release (lfa); gosub Extract_Free
Our embedded io routine does some post-write processing. This is called by the write lock record directive. It opens a reference file, reads it, then closes it. (There may also be some additional writing, based on results of this read.) Since _opt is 0, the next code line tries an extract release for lfa, but lfa was not the Chnl[_Found_chnl] in the write line. Changing lfa to Chnl[_Found_chnl] in the extract release line works fine in this situation.

However, there are other references to extracts and lfa elsewhere that I haven't gone through yet. These may be affected by post-read and post-write routines in embedded io routines.

Thought you'd like to know...

Language / Detecting Multi-Segment Split File
« on: January 27, 2023, 05:17:39 PM »
Is there a way to determine if a file is a multi-segment split file? We've got embedded io routines that do additional work based on a file's name. We're looking at splitting some of our larger files.
We would like to be able to parse out the base filename only, rather than have the full path and segment ID included. Being able to determine when to do the additional parsing work would certainly help.

Wish List / Re: Open Directory +INFO
« on: January 23, 2023, 11:41:11 AM »
This is for the online manual, and it's something that a lot of people probably don't know about but would find helpful. I probably should have save "cross-reference" instead of "link".

Wish List / Open Directory +INFO
« on: January 23, 2023, 09:59:35 AM »
Could there be a link in the documentation from the OPEN directive to the File Handling -> Processing Data Files -> Accessing Directory Files page, perhaps even to the Special Directory Processing paragraph...?

I use it enough to know what's there, but not enough to know exactly what is where.


Thin Client/WindX / Re: Automated Windx install
« on: November 14, 2022, 08:44:34 AM »
See also:
Silent Installation
here on the forum.

Nomads / Re: Data Dictionary File Sizing
« on: November 09, 2022, 11:53:10 AM »
That clears up a lot. Thanks.
I guess the same sort of applies to FLRs, though they're probably becoming rarer over time. (They seem to have the extra 'buffer' space, as well.)

Pages: [1] 2 3 ... 17