Skip to Content
0
Former Member
May 13, 2008 at 01:13 PM

Reload Matrx with New Data

118 Views

Hi,

I have create a Matrx with following statement:

CREATE MATRX (This work fine)

oForm.DataSources.DataTables.Add("DATA_Matrix");
oForm.DataSources.DataTables.Item("DATA_Matrix").ExecuteQuery("SELECT * FROM TableName WHERE FieldName = 'ComboSelection'");

RELOAD MATRIX (It crash here...)

Then I call my other method to refill the matrix:

oForm.DataSources.DataTables.Item("DATA_Matrix").ExecuteQuery("SELECT * FROM TableName WHERE FieldName = 'ComboSelection'");

But I get error message:

Data Table - invalid Unique Id [660000-138]

Any suggestion?

Thank you,

Rune