I wanted to know if the table component or the dataset has functions with which it is possible to find elements, remove elements, add elements (element by element) to it.
Could you give me a full list of functions for data sets and tables (such as Lookup(), range, colomncount, …). I miss these in the manual. Is it true there is no rowcount function for the dataset. I wanted it to loop through the whole dataset.
Here is what I need the functions for.
To reduce large amounts of small select queries my idea was to load a large dataset with all what the client might need during a session. I would for example load a dataset with the following columns using a select query to the database:
FactoryID TagID TagName
1 1 xxx
1 2 xxxx
1 3 xxx
2 4 yy
2 5 yyy
3 6 yyyy
Then I would loop through the whole dataset and look up what the user needs. For example all tagID’s and TagNames for the factoryID = 1. My idea then is to put the result into another dataset and work with it (e.g. display it in a drop down etc.) here comes my need for an add element function for the dataset. Is it possible? Do you have a better way of solving this?