Data source - Invalid table name [66000-7]
Hi,
I created UDO with master table and child table and when I tried to execute on it a dbdatasource query I got this error Data source - Invalid table name [66000-7]. When I tried this query on system table it works perfectly, so I don't know where is the problem (it looks like DBDataSources.Query doesn't work on user tables).
My code:
oDBDataSources = oForm.DataSources.DBDataSources.Add("@MyTable");
oConditions = (SAPbouiCOM.Conditions)(SBO_Application.CreateObject(BoCreatableObjectType.cot_Conditions));
oMatrix = (SAPbouiCOM.Matrix)(oForm.Items.Item("mtx_dzial").Specific);
oCondition = oConditions.Add();
oCondition.BracketOpenNum = 1;
oCondition.Alias = "U_MyDate";
oCondition.Operation = BoConditionOperation.co_BETWEEN;
oCondition.CondVal = "2008/10/01";
oCondition.CondVal = "2008/10/06";
oCondition.BracketCloseNum = 1;
oDBDataSources.Query(oConditions);
Regards
Ela