how to define a G.V. type and store a one dimension array in a G.V?

[huzhou81]

Hi all,
Any body know how to define and store a one dimension array in a blobal variable?
My one dimension array is initialized like :
Dim table(366)
For x=1 to 366
table(x)=0
next

because when I go through the records I need to change values in table(x).

I have tried to assigned
DTSGlobalVariables("v_table").Value = table

But I don't know how to define and initilize global variable in porpeties file. I got type mismatch error.

Anyone know how to solve this problems?

Thanks a lot.

 

[TomKane]

Hi,

Are you trying to put the contents of your table into an array?

Regards,
Tom

 

[AlexCuse]

I am not sure you can store an array in a global variable. What exactly are you trying to do with the array?

Good Luck,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[huzhou81]

The array will contain each days of one years' meeting number, for example, table(1) which stores Jan 1st 's total meeting numbers that will take place in location A. When I look through the records, I added up the preschedule meetings that will take place in location A in Jan 1st and compare the numer of meeting rooms location A have and to decide if the meeting room have been overbooked in location A in 1/1. same as table(31) which stores Jan 31's total preschedule meeting numbers in location A.

I have found in Web that I can stored this array as string use join function to global variable(String) and then use split function to convert global variable from string to array. I don't know what the maximum size of global varible will store, but anyway, I will try this solution to see if it work out.

If you have any tips, welcome to write comment and give me your ideas.

Thanks.