In this specific case cursor is no go.
Thank you.
>I can not resist, but a variable number of strings - this is what a cursor is for. In special in a language, that is designed for it ...
>
>Lutz
>
>>The values are not really related. But they are designed to address the issue of different ODBC drivers that the application could possible use (I had a thread about that a few days ago). Here are a couple of examples:
>>
>>*-- The name of the property has a table name with columns of type VarChar(Max)
>>oApp.VarCharMaxTable1 = "cast(Field1 as Text) as Field1, cast(Field2 as Text) as Field2)"
>>oApp.VarCharMaxTable2 = "cast(FieldA as Text) as FieldA"
>>
>>
>>As you can see (above) that I can store all these strings into elements of an array or have a separate variable.
>>Thank you.
>>
>>>Depends. If the values are related, like different days of a month, use an array. If not, use properties with proper names.
>>>
>>>What kind of data will go into these properties?
>>>
>>>>Hi,
>>>>
>>>>I need to add some properties (all of type string) to the application class/object. It will probably start with about 10 but may grow to about 70 variables (in time). I can create each as a separate string property or combine them all into an array property.
>>>>Example:
>>>>
>>>>oApp.Property1
>>>>oApp.Property2
>>>>*-- vs
>>>>oApp.aProperty[1]
>>>>oApp.aProperty[2]
>>>>
>>>>
>>>>Which approach is a better practice, in terms of memory management at run-time?
>>>>
>>>>TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham