Hi,
I'm running 9.5, testing an SAP transaction. I'm importing a data table which is working fine. It has three rows of data. I selected the "run on all rows" option. The problem I'm having is that is doesn't seem to know when to stop running.
Here is a portion of my code:
' rows of SAP code which are working fine
I have very little experience with the syntax of the loop statements. I want the code to realize that once it gets to row 5, that there is no more data. I only want it to import the speadsheet once. And the number of rows with data will change so I don't want to hard code it or have to change the run options. Thanks in advance for your help.
Mike
I'm running 9.5, testing an SAP transaction. I'm importing a data table which is working fine. It has three rows of data. I selected the "run on all rows" option. The problem I'm having is that is doesn't seem to know when to stop running.
Here is a portion of my code:
Code:
1: DataTable.Import "C:\Temp\CreateVendor2.xls"
2: Do While DataTable.GetCurrentRow <> ""Code:
33: Datatable.SetNextRow
34: LoopI have very little experience with the syntax of the loop statements. I want the code to realize that once it gets to row 5, that there is no more data. I only want it to import the speadsheet once. And the number of rows with data will change so I don't want to hard code it or have to change the run options. Thanks in advance for your help.
Mike