Skip to main content

DATA_UOM

DATA_UOM: TvxClientDataSet

Example​

procedure ScriptEvent(var Value: variant);
begin
  CreateData(DATA_UOM, ['Num,integer', 'Code,string,50', 'UomCode,string,50', 'Description,string,100']);
  DATA_UOM.Append;
  DATA_UOM['Num'].AsInteger := 1;
  DATA_UOM['Code'].AsString := 'EACH';
  DATA_UOM['UomCode'].AsString := 'EA';
  DATA_UOM['Description'].AsString := 'Each';
  DATA_UOM.Post;
  Value := DATA_UOM.RecordCount;
end;

Usage​

DATA_UOM provides the friendly dataset conventionally used for VxData unit-of-measure reference data.

Conventional VxData context

The current Uom table is application/type scoped and distinguishes the integration/application Code from the standard or external UomCode. It also stores description, validity and audit data.

This convention guides queries and field names; it is not a runtime schema contract. Custom SQL, configuration and customer extensions may return a different subset, aliases or additional columns. Use FindField for optional fields and validate types at the integration boundary.

Behaviour, lifecycle and side effects

  • Velox loads all returned rows into memory and preserves fetched string whitespace. Large results can use substantial memory.
  • Navigation, filtering, indexing and edits mutate the shared object. Closing or recreating it invalidates retained fields, bookmarks and record positions.
  • Post updates the client dataset; it does not prove an external database write or transaction commit. Persistence belongs to the function or SQL used for that purpose.
  • Data helpers commonly catch and log SQL or creation failures, potentially leaving the object inactive or reset. Invalid field, conversion and dataset-state operations can still raise.
  • Action cleanup closes friendly datasets. Velox owns the object; scripts must not free it or rely on its records surviving another action execution.
  • The mutable dataset and cursor are not thread-safe. Do not pass the reference to asynchronous work or allow nested code to reposition it without an explicit contract.

Additional Technical Info​

DATA_UOM is an action-owned friendly dataset intended for the role described below. It is a live TvxClientDataSet reference; its name does not load data, select a connection, execute SQL or impose a field layout.

Runtime binding and identity

Velox constructs the object with the action and binds DATA_UOM to TvxActionMan.FData20. Its diagnostic dataset name is DATA_UOM.

The dataset begins inactive and without fields. CreateData, Data query helpers and load methods can each replace its schema and records. Every script using the action observes the same live cursor, filters, indexes and edits until it is closed or repopulated.

Implementation and naming cautions

Code and UomCode can differ, and neither field alone supplies a conversion factor, dimensional category or rounding rule. Use an explicit product/UOM mapping or configured conversion contract when quantities change basis.

The friendly suffix does not validate record type, authenticate a user or party, enforce application/tenant scope, apply foreign keys or prevent reuse for unrelated data.

Related entries

External references

Created 2026-07-15