cancel
Showing results for 
Search instead for 
Did you mean: 

I wanna change DataTable to DBDataSource Is it possible?

Former Member
0 Kudos

I wanna change DataTable to DBDataSource Is it possible?

Here are example.

Dim DataTable01 As SAPbouiCOM.DataTable

Set DataTable01 = oForm.DataSources.DataTables("DataTable")

DataTable01.ExecuteQuery ("SELECT ItemCode,ItemName FROM OITM")

Call oMat1.Columns("ItemCode").DataBind.Bind("DataTable", "ItemCode")

Call oMat1.Columns("ItemName").DataBind.Bind("DataTable", "ItemName")

oMat1.LoadFromDataSource

in here, Data is loaded

field of itemcode is binded datatable but i wanna change to dbdatasource becaseof udo

so i tried this code

Call oMat1.Columns("ItemCode").DataBind.SetBound(True, "OITM", "ItemCode")

Call oMat1.Columns("ItemCode").DataBind.SetBound(True, "OITM", "ItemName")

but there are error "Matrix - Line Exist"

is'nt is possible?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Its not possible.

Regards,

Siva

Former Member
0 Kudos

Hello,

I have same problem.

Can you give me alternate solution for this.

Leena

Former Member
0 Kudos

There is no way,

Just Use DBDatasource.

Thanks

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks