A Better Way to Retrieve Row and Column Data

A Better Way to Retrieve Row and Column Data

Instead of creating a GridControl to retrieve row and column data from a table into a hash table, use a variant, as shown:

 variant = new Variant();for (row2get=0;     row2get < queryDataSet1.getColumnCount();     row2get++) {  for (column2get=0;       column2get < queryDataSet1.getColumnCount();       column2get++) {         queryDataSet1.getVariant(int row2get,            int column2get,variant);         String bean = (String)variant;         HashTable.put("columnName",            new String(bean));    }}

You can now cast the data from the variant object to the appropriate type to retrieve the information. This is particularly handy when serializing an object created from a database, since you can ask for the data by column name. You can also use "tiered hash tables" to capture master-detail relationships.

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular