dbsync_core.t_tabinfo type

The t_tabinfo type defines a dynamic array of SQL table DB Sync information.

Syntax

TYPE t_tabinfo DYNAMIC ARRAY OF t_tabinfo_rec

Usage

Define a variable of type t_tabinfo to hold the list of SQL tables used by the client application.

The list of SQL tables needs to be registered with the dbsync_app.register_local_tables() function.

Example

 DEFINE tabinfo dbsync_core.t_tabinfo
 LET tabinfo[1].table_name = "customer"
 LET tabinfo[2].table_name = "order"
 LET tabinfo[3].table_name = "cclines"
 IF dbsync_app.register_local_tables(tabinfo) < 0 THEN
     DISPLAY "Could not register SQL tables!"
     EXIT PROGRAM 1
 END IF