G
Guest
I am working with a language that's a dialect of VB (old one called BasicScript.) I have to fill an array with the text values contained in variables and write them out using a SQL Server stored procedure. My code so far is
Dim RejResArray(12) As Strin
For i = 1 to 1
RejResArray(i) = Reject1.Tex
Nex
The variables are coming from a separate application that I don't have much control over, and are named Reject1 -- Reject12. I would like to test each variable to see if it's null or '' and then assign it to the array if it's not. In another language I work with, I am able to have the suffix number of the variable fill in once I know the results of the test. (so something like RejResArray(i) = Reject&j.Text where j is the number of the variable that passes the test.) Is there a way to do something similar in VB? (I'll worry about the basicscript after knowing that.)
Dim RejResArray(12) As Strin
For i = 1 to 1
RejResArray(i) = Reject1.Tex
Nex
The variables are coming from a separate application that I don't have much control over, and are named Reject1 -- Reject12. I would like to test each variable to see if it's null or '' and then assign it to the array if it's not. In another language I work with, I am able to have the suffix number of the variable fill in once I know the results of the test. (so something like RejResArray(i) = Reject&j.Text where j is the number of the variable that passes the test.) Is there a way to do something similar in VB? (I'll worry about the basicscript after knowing that.)