Search found 21 matches

by msddcb
Tue Sep 19, 2023 11:20 pm
Forum: General
Topic: STRPCCMD gives MS explorer error
Replies: 9
Views: 4570

Re: STRPCCMD gives MS explorer error

While I am not able to help with your problem I was interested in Scott's reply. Firstly would you just replace the CMD with WINWORD.EXE ? (Presuming the windows path enables the program to be found) And more interestingly if going the new http server option is this still accessing the document on t...
by msddcb
Mon Aug 14, 2023 1:10 am
Forum: JDBCR4
Topic: JDBCR4 call to MSSQL Stored Procedure does not return a result set
Replies: 1
Views: 6383

JDBCR4 call to MSSQL Stored Procedure does not return a result set

We have been using JDBCR4 to run SQL statements and Stored Procedures on a MS SQL server for a long time. Client has moved to a new cloud based server and a few stored procedures are not returning anything. This is a later version of MS SQL Server In debug I can see the result of isResultSet = JDBC_...
by msddcb
Wed Jul 12, 2023 3:08 am
Forum: HSSFR4
Topic: trouble with formulas
Replies: 12
Views: 11598

Re: trouble with formulas

But was there data in every row up to 2000 ?

I was suggesting the sum just include the rows with data
by msddcb
Mon Jul 10, 2023 9:43 pm
Forum: HSSFR4
Topic: trouble with formulas
Replies: 12
Views: 11598

Re: trouble with formulas

I do not know if it would make any difference but your formula is using an entire column.

Just for a test could you change your formula like this

=SUMIF(D4:D40,BJ4,J4:J40)/2000 in column BK4

Where 40 is the last row of data your program writes.

And see if that makes any difference.

Cheers, Don
by msddcb
Wed Jun 07, 2023 9:17 pm
Forum: HSSFR4
Topic: xmlbeans download
Replies: 10
Views: 9343

Re: xmlbeans download

3.6 is quite old, do you have a specific reason for using 3.6 ? We are running 3.14 which is the last version compatible with HSSFR4 after that POI classes started using ENUMS. Looking at my classpath the xmlbeans is the same jar I have used since we started using HSSFR4 many years ago. Here is what...
by msddcb
Thu May 11, 2023 9:35 pm
Forum: RPG IV
Topic: IFS Path Validation
Replies: 7
Views: 6112

Re: IFS Path Validation

Change you write to only write the data portion of the variable length field WriteFile(l_fd:%Addr(l_Data : *DATA):%Len(l_Data)); The first 2 characters you are seeing is the length of the variable length field. See ... https://www.ibm.com/docs/en/i/7.4?topic=functions-addr-get-address-variable Cheers
by msddcb
Tue Feb 21, 2023 5:07 am
Forum: RPG IV
Topic: Embedded SQL Isolating Hour from Time Field
Replies: 4
Views: 4418

Re: Embedded SQL Isolating Hour from Time Field

I think this should work ...

Code: Select all

select COUNT(*), CustNumber, TranDate, substr(digits(IsoTranHour),1,2), Sum(TranAmount)
from Tranfile
where TranDate = 44976
group by CustNumber, TranDate, substr(digits(IsoTranHour),1,2)
order by CustNumber, TranDate, substr(digits(IsoTranHour),1,2)
by msddcb
Tue Dec 06, 2022 11:14 pm
Forum: Other ScottKlement.com Tools
Topic: Support for SMTP_Auth
Replies: 3
Views: 3988

Re: Support for SMTP_Auth

Hi Scott,

I am also looking for the same answer.

We have been using SMTPR4 for a very long time and now we need to authenticate with Office365 and I am trying to find either an example of the format of the SMTP request that authenticates or how to modify SMTPR4 to do so.

Thanks

Don
by msddcb
Mon Jan 24, 2022 11:25 pm
Forum: HSSFR4
Topic: DocumentHelper-Illegal recflective access
Replies: 5
Views: 7378

Re: DocumentHelper-Illegal recflective access

The latest version of HSSFR4 supports POI Version 3.14 and earlier.
Later versions of POI will require modification to the service program as some of the parameters have been change to enum.
Cheers, Don
by msddcb
Wed Nov 10, 2021 10:58 pm
Forum: HTTPAPI
Topic: SoapAction
Replies: 10
Views: 20656

Re: SoapAction

I have a number of previous versions and example 20 only has
** XML-RPC example
c eval *inlr = *on
In every version.