SAPbouiCOM.Conditions --OrderBy

[Former Member]

SAPbouiCOM.Conditions oConds = new SAPbouiCOM.Conditions();

SAPbouiCOM.Condition oCond;

can i write ORDER BY Query using the 'SAPbouiCOM.Condition'

If any one know pleas e reply

[Nussi]

Hi,

there's still no way to sort a condition.

the condition object has still no property for this included.

regards

David

[Former Member]

ok

then how can i execute direct query in 'DBDataSource'

[Nussi]

Mona,

it depends what you want to do.

if you want to fill a matrix or a grid with a query use the DataTable object !

than you have .ExecuteQuery

lg David

[Former Member]

Hi david

How can load data to matrix using datatable

Thanks

[Nussi]

Hi Mona,

here's a c# sample:

oForm.DataSources.DataTables.Add("OPRJ");
oForm.DataSources.DataTables.Item("OPRJ").ExecuteQuery("SELECT PrjCode, PrjName FROM OPRJ ORDER BY PrjCode");

((SAPbouiCOM.Matrix)(oForm.Items.Item("mtxList").Specific)).Columns.Item("1").DataBind.Bind("OPRJ", "PrjCode");
((SAPbouiCOM.Matrix)(oForm.Items.Item("mtxList").Specific)).Columns.Item("3").DataBind.Bind("OPRJ", "PrjName");

((SAPbouiCOM.Matrix)(oForm.Items.Item("mtxList").Specific)).Clear();

((SAPbouiCOM.Matrix)(oForm.Items.Item("mtxList").Specific)).LoadFromDataSource();

lg David