API refresh load table

[Anonymous]

I wrote script to create, modify and delete bar loads via API. The problem is that when load has been deleted the corresponding row in load table does not disappear. If new loads are added via API, these empty rows will be filled and this will cause some problems to my API script.

I would like to know if there is some piece of code that will refresh load table and remove all empy row from load table.

[Rafal.Gaweda]

Close the table before deleting records or afterwards close it and reopen

[Anonymous]

Is it possible to close and reopen load table via API? I would like give some kind of refreshing command to Robot via API.

I noticed that empty rows will disappear if I close and reopen load table. My problem is that, when I add new loads via API, these new loads will be located to these empty rows in load table instead of the end of the load table. Thus indices of these loads will be smaller than some old loads, that locates in the end of the load table. Because of that, I cannot assume that index of new load would be the largest index of load records. This leads to some kind of problems in my script.

[Rafal.Gaweda · Accepted solution]

Dim t As RobotTable
'open table
Set t = RobApp.Project.ViewMngr.CreateTable(I_TT_LOADS, I_TDT_DEFAULT)
'close table
t.Window.SendMessage 16, 0, 0

[Anonymous]

Thanks Rafal! This code creates Load table and then close it. Unfortunately this refreshing of load table won't affect to indices of load records. Indices of load records that have been deleted are not removed.

However, I figured out some other way to avoid this index problem of load records.

[anacffaria]

Hello @Rafal.Gaweda 

Can you kindly explain how to open the Quantity Survey table using that method?

Many thanks!

[Rafal.Gaweda]

Hi @anacffaria 

Example code:

Dim RobApp As RobotApplication
Set RobApp = New RobotApplication
Dim t As RobotTable

Set t = RobApp.Project.ViewMngr.CreateTable(I_TT_MEASURE, I_TDT_VALUES)