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 ... 13
Programming / Re: Opening Excel Workbook while open in *obj/excel
« on: November 18, 2021, 12:16:44 PM »
Part of our output selection routine now includes XLSX. The routine required access to a file, and I was trying to link the actual Workbook file to the channel. To make things easier all around, the Workbook is opened through the object, and the channel# is pacified with /dev/null.

Programming / Opening Excel Workbook while open in *obj/excel
« on: November 17, 2021, 09:54:51 AM »
Is there a way to open an Excel workbook on a file channel while it's being processed with *obj/excel? I get an Error #12 even if the workbook is being accessed via 'OpenWorkbook().
Conversely, if I open the workbook as a file first, I can still get to it through *obj/excel. Which is OK, if the workbook already exists. But if I need to 'CreateWorkbook(), there's a bit of a problem.
This doesn't seem to be a problem if the workbook is opened directly in Excel.

Off Topic / Re: BBx to Notepad
« on: October 27, 2021, 09:46:07 AM »
If you're still running under BBx, you can LIST the program directly to a file:

LOAD "progname"
STRING "filename"
OPEN (Chan)"filename"
LIST (Chan)
CLOSE (Chan)

It's then in a text file for review. Standard Notepad open rules apply.

Language / Re: Program Size limitation?
« on: September 28, 2021, 04:11:51 PM »
Already accounting for line numbers and lengths. Yes, the total number of variables plus the additional 3 bytes brings the total to over 40K.
The intent was to have a single repository of IOLISTs for use in programs that don't open files with iol=*. An updated IOLIST could be retrieved and dropped into the program, if needed.
Thanks for the clarification.

Language / Program Size limitation?
« on: September 28, 2021, 02:10:34 PM »
We're still upgrading many of the program from our legacy system which uses explicit IOLISTs in the programs. As we update file definitions in Nomads, we also need to update some of these IOLISTs. To help, we've got a program that runs through the Nomads Data Dictionary and creates an IOLIST statement for the defined files, including non-normalized variants. These are loaded out to a line-numbered text file, then run through "*pg.cnv" to convert to a tokenized program.

Trying to run it today, I get an Error #19: Program size too large. The program itself is only about 74K. But is there a limit on the number of variables or the size of the variable table? From what I see, we've got about 3200 different variable names defined in the program (before it stopped accepting more). The program itself consists of !Comments and IOLISTs.

Any insights would be appreciated. Thank you!

Nomads / Enter Key in Grid
« on: September 16, 2021, 05:21:18 PM »
I've got a grid with all cells locked except for 2 non-adjacent columns. If I change a value and Tab out, it moves to the next cell. If I don't change the value and Tab or Enter, it moves to the next cell. But if I change a value and Enter out, it ALWAYS moves to the next control, not the next cell in the grid. I've set the 'TabMode and 'EnterMode properties' values to everything, but it's still the same.
Also, %Nomads'Enter_Tab=1.
Am I missing something? I'd like the Enter on a changed cell in a grid to work the same as a Tab.

Language / Re: Err=99 - NEW() not supported
« on: September 15, 2021, 03:59:57 PM »
A note in the documentation might be helpful, so those not familiar with such intricacies might be better informed.

Language / Re: Err=99 - NEW() not supported
« on: September 15, 2021, 02:23:14 PM »
Different, but somewhat related:
We rattled our brains a bit here trying to instantiate the *obj/excel object. We were also getting Error #99. Then I tried:
and it worked. Could the documentation be updated to reflect the self vs client (WindX) usage, please? I presume it would also apply to *obj/word.

Thank you!

Programming / Re: ENTER using default values
« on: August 25, 2021, 03:57:19 PM »
The documentation specifies that the default values will only apply if the argument is missing, not if it's null. You've provided the arguments in the CALL statement, and their values are null. If you leave the variables off the CALL statement completely, then the defaults will apply.

I already found the problem and corrected it. Thanks.

I've got a file with a secondary key of:
PO_Date/d + PO_Num + Cust + ShipTo + Seq

I can read directly through the file with no problems. But if I want to grab the first entry in a group and skip the rest of the Seq values, I issue:
read (F,key=PO_Date$:PO_Num$:Cust$:ShipTo$:$FF$)

It always goes to the end of file at this point. The file is created properly, with the first field descending and the remaining ascending. Am I missing something?

Thanks, all!

Nomads / Data Dictionary - Field Counts and Arrays (Occurs)
« on: June 07, 2021, 03:54:19 PM »
When defining arrays in the Data Dictionary, the field "number" on the main grid doesn't reflect the number of entries in the array (it only counts 1), whereas a single variable with multiple fields will adjust the count for all of them. When printing the formats, however, the field count is represented properly in both cases.

I'm thinking this is just an oversight, but wanted to be sure I'm not missing something.

Thank you!

Programming / Re: Does PID Exist
« on: May 20, 2021, 10:24:02 AM »
According to the documentation:
"The SYS function can be used to determine the state [of] another process on the system. [T]he SYS function will return zero if the specified process is still executing or -1 if the process cannot be found ..."

Language / CREATE FILE from *memory*
« on: April 15, 2021, 12:00:27 PM »
I'm creating a temporary text file so it can be completely done before dropping it into the final destination directory for export. This time, I'm printing the lines to a *memory* file. However, when I try:

create file OFile$ from (OFile)

to create the disk file from the memory file, it throws Error #13. Is this appropriate? Do I have to create a REAL file to be copied?

Thanks in advance!

Language / Re: Directory +INFO
« on: April 09, 2021, 09:57:22 AM »
Thanks, guys!

Pages: [1] 2 3 ... 13