Switch to: V9V8V7V6V5

KEYVALUE DELETE

Syntax

KEYVALUE keyvalue_name [OF TABLE table_name | OF LINK link_name]
    DELETE [LIKE] ( vext_key_list )

vext_key_list
    :    vext_key, ...

vext_key
    :    character_string_literal
    |    variable_name
    |    dynamic_parameter_specification

Description

This command is analog of DELETE command for tables. You can use it to delete the specified key(s) and their corresponded value(s).

LIKE

LIKE allows you to execute START WITH search for KeyValues WITH KEY, i.e. with KeyValues which have a complex structure of key and which is known to Valentina Database.

You should specify the start of keys, which you want to delete. See example below.

Notice, that KeyValue FOR TABLE and FOR LINK, also are KeyValues WITH KEY, so LIKE search can be used also.

Example

KEYVALUE kvProperties DELETE ( '545.name', '545.age' )

Example

--
-- remove all keys LIKE 545.*
--
KEYVALUE kvProperties DELETE LIKE ( '545' )