Table Class

Properties   Methods   Events   Configuration Settings   Errors  

The Table Component provides an easy interface to Microsoft's Windows Azure Table Service.

Class Name

InAzure_Table

Procedural Interface

 inazure_table_open();
 inazure_table_close($res);
 inazure_table_register_callback($res, $id, $function);
 inazure_table_get_last_error($res);
 inazure_table_get_last_error_code($res);
 inazure_table_set($res, $id, $index, $value);
 inazure_table_get($res, $id, $index);
 inazure_table_do_addentityproperty($res, $name, $valuetype, $value);
 inazure_table_do_config($res, $configurationstring);
 inazure_table_do_createtable($res);
 inazure_table_do_deleteentity($res, $partitionkey, $rowkey);
 inazure_table_do_deletetable($res);
 inazure_table_do_doevents($res);
 inazure_table_do_getentity($res, $partitionkey, $rowkey);
 inazure_table_do_insertentity($res, $partitionkey, $rowkey);
 inazure_table_do_interrupt($res);
 inazure_table_do_listentities($res);
 inazure_table_do_listtables($res);
 inazure_table_do_mergeentity($res);
 inazure_table_do_reset($res);
 inazure_table_do_resetheaders($res);
 inazure_table_do_updateentity($res);

Remarks

The table component allows you to easily access the Azure Table Service. You can use the component to create, modify, and delete tables, entities, and entity properties. A brief description follows, but please refer to Microsoft Azure Table Service Concepts for additional details on Azure Tables.

Before using the Table component you will first need to create an Azure Storage Account to obtain the AccessKey and Account

To begin you may add tables using the CreateTable method. Entities may be created using InsertEntity method. Entities are identified within a table by the PartitionKey and RowKey. Methods relating to entities will take partitionKey and rowKey as parameters. For instance to update an entity:

table.Reset
table.TableName = "YourTableName"
table.AccessKey = "YourAccessKey"
table.Account = "YourAccount"

'Get the existing properties of an entity in a table
table.GetEntity "MyPartitionKey","MyRowKey" 

'Output the value of the 1st entity
Debug.Print(table.EntityPropertiesValue(0))

'Change the Entity value
table.EntityPropertiesValue(0) = "NewValue"

'Add a new Entity property
table.AddEntityProperty "testString", 7, "My New String" 
      
'Update the entity
table.UpdateEntity

Additional methods and properties can be used for further operations on tables, such as DeleteTable DeleteEntity InsertEntity MergeEntity etc.