This is more of an VB problem but i am doing this in Access so I'm making the post here.
QUESTION: If a function is of type String Array (i.e. string() ) is there any way to reference an element without VB thinking i'm trying to call the function again recursively?
Public Function Test (MyVar as Long) as string()
' The next line of code needs to reference an element in the array
' Not call Test again recursively.
' When run VB thinks i'm trying to call test again and pass in 0
Test(0) = "I want to pop this string into the first element"
This probably won't mean much as you pretty much need to have the system requirements to see why I need this but I am building an Integration Utility. The first element holds the File header. and any other element that comes after that holds SQL statement fragments (which can vary from 1 to X). It looks like i'll be using a function that is of type "user defined" and place my array there.