Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Not what you were looking for? View more on this topic or Ask a question