BS Datatable struggle

lotsofcows · April 21, 2019, 11:07am

Trying to get my head around BSdatatables. Following is my code, largely BSDatatable sample, but DataTable1.build() doesn’t seem to refresh the table. If I click on a cell it shows me the data from my arrays but it’s not displayed. Just shows 2 rows and 3 cols from design screen. It works with my data in the sample project but I can’t get it into my project. Any ideas?

JavaScript
var columns1 = [
{title: &quot;code&quot;},
{title: &quot;name&quot;},
{title: &quot;stocktype&quot;},
{title: &quot;cost&quot;},
{title: &quot;qtyonhand&quot;},
{title: &quot;minreqrd&quot;},
{title: &quot;maxreqrd&quot;},
{title: &quot;onorder&quot;},
{title: &quot;sellprice1&quot;},
{title: &quot;sellprice2&quot;},
{title: &quot;sellprice3&quot;},
{title: &quot;margin1&quot;},
{title: &quot;margin2&quot;},
{title: &quot;margin3&quot;},
{title: &quot;onhand&quot;},
{title: &quot;sell1&quot;},
{title: &quot;sell2&quot;},
{title: &quot;sell3&quot;},
];

var data1 = [

[&quot;INSYTECATHETER&quot;,&quot;BD Insyte Catheter 22G x 1&quot;,&quot;6&quot;,&quot;2.75&quot;,&quot;5&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;5.5&quot;,&quot;4.68&quot;,&quot;4.68&quot;,&quot;100&quot;,&quot;70.1818&quot;,&quot;70.1818&quot;,&quot;5&quot;,&quot;5.5&quot;,&quot;4.68&quot;,&quot;4.68&quot;],

[&quot;0DIB1H&quot;,&quot;Don't use Expired2&quot;,&quot;1&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;38.68&quot;,&quot;35.31&quot;,&quot;35.31&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;38.68&quot;,&quot;35.31&quot;,&quot;35.31&quot;],

[&quot;0DIB2H&quot;,&quot;Don't use Expired3&quot;,&quot;1&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;12.06&quot;,&quot;11.74&quot;,&quot;11.74&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;12.06&quot;,&quot;11.74&quot;,&quot;11.74&quot;],

[&quot;0DIB3H&quot;,&quot;Don't use Expired4&quot;,&quot;1&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;6.9&quot;,&quot;6.97&quot;,&quot;6.97&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;6.9&quot;,&quot;6.97&quot;,&quot;6.97&quot;],

[&quot;1-XX&quot;,&quot;Penalty interest5&quot;,&quot;1&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;,&quot;0&quot;]

];

End JavaScript

Function Form1Main()
updateTable()
End Function

Function DataTable1_onclick(event)
If typeof(event.target._DT_CellIndex) &lt;&gt; &quot;object&quot; Then return
Dim row, col
row = event.target._DT_CellIndex.row
col = event.target._DT_CellIndex.column
MsgBox &quot;Click on &quot; &amp; row &amp; &quot;, &quot; &amp; col &amp; &quot;. Value is '&quot; &amp; data1[row][col] &amp; &quot;'.&quot;
End Function

Function updateTable()
DataTable1.settings.columns = columns1
DataTable1.settings.data = data1
DataTable1.build()
End Function

lotsofcows · April 22, 2019, 1:54am

Turns out table.build() function had to be called from Main() to start/initialise the datatable. Can be called again later from anywhere, just the first time needs to called from Main().
5 hours of my life later I’ve got the data displaying.

My only issue now is my datatable is scrolling because it is too wide obviously but the column headers don’t scroll with the data columns. Is there a fix for that?

pedau · April 23, 2019, 11:38pm

Is there any particular reason why you are using the BS datatable over other grids such as Jqxgrid?
I was using BS datatable a while back but was running into similar issues as you so went back to Jqxgrid. I initially had issues with Jqxgrid scrolling and speed performance but managed to solve them.

lotsofcows · April 25, 2019, 9:53pm

Thank you. Nice to know it’s not just me. Does Jqx play nicely with Bootstrap? Assume it doesn’t like JQuery.

pedau · April 25, 2019, 11:36pm

I am using a fair bit of Jqx and Bootstrap and it works fine. I have swapped out all JQuery controls.
Initially, i couldn’t get 100 records to scroll smoothly using Jqxgrid then changed the way i coloured the grids, and now everything is fast and appearance is better than BS.

ghenne · April 26, 2019, 12:11pm

Yes, jqWidgets plays nicely with Bootstrap 3 or 4.