I don't know which forum to put this in, I don't think a lot of people do this (with Telnet), I made a script that reads data from an Excel and can enter data into AS400 screens.
I have it working pretty good, but for some reason won't read past a certain number of Excel rows.
I don't want to post all the code yet as it will likely distract, what I am seeing as the issue.
eg...
Variable $COL9 is getting it's values, I put in a message box to display it...but it works if I the variable equals 9 ( or less), after that nothing happens...If I hardcode this line...
for {i = 2} {$i <= 17 } {incr i } {
where I replaced $COL9 with 17 it will work???
I have it working pretty good, but for some reason won't read past a certain number of Excel rows.
I don't want to post all the code yet as it will likely distract, what I am seeing as the issue.
eg...
Variable $COL9 is getting it's values, I put in a message box to display it...but it works if I the variable equals 9 ( or less), after that nothing happens...If I hardcode this line...
for {i = 2} {$i <= 17 } {incr i } {
where I replaced $COL9 with 17 it will work???
Code:
conv = [dde initiate Excel Order.XLS]
#Increment by row
# Total number of rows including Header in order file
COL9 = [dde request $conv "R2\C9"]
message "Record Count $COL9"
for {i = 2} {$i <= $COL9 } {incr i } {
# Code
}