Array Processing/Variable Question

  • Thread starter Thread starter Guest
  • Start date Start date
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.)
 
* "=?Utf-8?B?a2I=?= said:
The variables are coming from a separate application that I don't have
much control over, and are named Reject1 -- Reject12.

How does the other application make these "variables" accessible?
 
The application uses what it calls "virtual" variables which are part of the form object. It then allows for scripting behind the form. I can create local or global variables in the script, but when the form unloads, those go away and are unavailable for export. (If I could just use normal variables, this wouldn't be an issue) The virtual variables that are part of the form remain and are available for export. For the most part I can use them just like a normal VB variable.
 
Hi Kb,

In VB.net a variable is not equal to the old classic VB variable, that is
one of the big differences.

Maybe you can try it in more classing newsgroups as

microsoft.public.VB
or
microsoft.public.scripting.vbs

I hope you find your solution.

Cor
 
Back
Top