Switch to: V9V8V7V6V5

VTable Class: KeyValue Methods

VTable.CreateKeyValue()

Declaration:

CreateKeyValue( 
    inName as String,
    inOptions as Int64 )

Parameters:

  • inName - The name for new KeyValue.
  • inOptions - Bitset of options.

Description:

Creates a new empty KeyValue For Table.

You can specify options:

kTemporary kCompressed Temporary KeyValue keeps files on .tmp volume of Valentina database. Information about such temporary database object is not saved into system tables.

Compressed KeyValue does compression of Big Values. These are values that go into internal segment file (like BLOB). Picture values are not compressed.

Example:

dim kv as VKeyValue = tbl.CreateKeyValue( "kvMoreFields" )

VTable.DropKeyValue()

Declaration:

DropKeyValue( inKeyValue as VKeyValue )

Parameters:

  • inKeyValue - The KeyValueForTable that should be deleted.

Description:

Removes the specified KeyValueForTable.

Example:

tbl.DropKeyValue( kv2 )

VTable.KeyValue(index)

Declaration:

KeyValue( inIndex as Integer ) as VKeyValue

Parameters:

  • inIndex - The index of a KeyValue in a database, starts from 1.

Description:

Returns a KeyValue by a numeric index.

Example:

kv = tbl.KeyValue( i )

VTable.KeyValue(name)

Declaration:

KeyValue( inName as String ) as VKeyValue

Parameters:

  • inName - The Name of a KeyValue.

Description:

Returns a KeyValue by name.

Note: The parameter inName is case insensitive.

Example:

kv = tbl.KeyValue( "kvMoreFields" )