Search found 21 matches
- Tue Sep 19, 2023 11:20 pm
- Forum: General
- Topic: STRPCCMD gives MS explorer error
- Replies: 9
- Views: 12479
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...
- 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: 16478
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_...
- Wed Jul 12, 2023 3:08 am
- Forum: HSSFR4
- Topic: trouble with formulas
- Replies: 12
- Views: 20893
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
I was suggesting the sum just include the rows with data
- Mon Jul 10, 2023 9:43 pm
- Forum: HSSFR4
- Topic: trouble with formulas
- Replies: 12
- Views: 20893
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
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
- Wed Jun 07, 2023 9:17 pm
- Forum: HSSFR4
- Topic: xmlbeans download
- Replies: 10
- Views: 17044
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...
- Thu May 11, 2023 9:35 pm
- Forum: RPG IV
- Topic: IFS Path Validation
- Replies: 7
- Views: 11963
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
- Tue Feb 21, 2023 5:07 am
- Forum: RPG IV
- Topic: Embedded SQL Isolating Hour from Time Field
- Replies: 4
- Views: 9151
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)
- Tue Dec 06, 2022 11:14 pm
- Forum: Other ScottKlement.com Tools
- Topic: Support for SMTP_Auth
- Replies: 3
- Views: 8510
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
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
- Mon Jan 24, 2022 11:25 pm
- Forum: HSSFR4
- Topic: DocumentHelper-Illegal recflective access
- Replies: 5
- Views: 12897
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
Later versions of POI will require modification to the service program as some of the parameters have been change to enum.
Cheers, Don
- Wed Nov 10, 2021 10:58 pm
- Forum: HTTPAPI
- Topic: SoapAction
- Replies: 10
- Views: 21044
Re: SoapAction
I have a number of previous versions and example 20 only has
** XML-RPC example
c eval *inlr = *on
In every version.
** XML-RPC example
c eval *inlr = *on
In every version.