Peoblem loading a second table without reinitiate the vb prg

[raul]

I load a Tabke from Access and using PCX.CubeMeasures.Add and PCX.MapAddCalculatedMeasure from vb program.
click to load another Table with other fields and another CubeMeasures and MapAddCalculatedMeasure
delete previous Measures with
For i = 0 To PCX.CubeMeasures.Count
PCX.CubeMeasures.delete (i)
Next i
and
For i = 0 To PCX.MapMeasureCount
PCX.MapDeleteCalculatedMeasure (PCX.MapMeasures(i).name)
Next i

and have a conflict. measures beacause they still are there although deleting

I need to load data without closing prograam and restarting
Thanks

[AlexZencovich]

1. Better will use CubeMeasures.Clear method

2. In your code fro Calc. measures you have a little bug - when you delete item (0), the item (1) become item(0) but loop variable become 1 so actually you delete item(2) etc....

Right loop will like next pseudocode example

for i := Count -1 downto 0 do
Delete(i)

or

while Count > 0 do
Delete(0)