DbDataTable() function - Is there DbCursorFromDataTable() function???

Anonymous · Post by **Anonymous** » Wed Apr 22, 2020 8:01 pm

Robert - I see in the What’s New file version 2.4 that there’s a new function called DbDataTable(), so I want to ask if there is also a function that will create a data table from a local cursor?

robert · Post by **robert** » Wed Apr 22, 2020 9:05 pm

Matt,
Sure we can add that. But why would you need that ?
To show data on a .Net control (DataGridview for example) you need a bindable .Net collection and not a cursor.
That is why we added DbDataTable() and DbDataSource().

Robert

FoxProMatt · Post by **FoxProMatt** » Thu Apr 23, 2020 12:09 am

Okay, you’re teaching me here... I wasn’t aware of BindingList in .Net, so after some reading, I see what you are saying.

I’ll keep reading and experimenting.

I’m especially curious to see how X# keeps the Cursor updated from changes in the BindingList as stated in the What’s New file.

Updates to properties in the bindinglist will be directly written to the attached workarea.

Keeping data sets synchronized is hard.. what if I delete a row from the WorkArea after the BindingList is created? Or add a new row to the WorkArea?