DBGate Sample 16 - Symbol Lists

This sample shows how to create forms to work with many-to-many relations.

Symbol Lists

Suppose we have a table of stock lists like s16_list_symbols. It is much better to use a form like the following.

You can use space to create or delete the pair.

This feature has a trick. The s02.xl_app_handlers sets the BitColumn type for list columns. Here is a view result.

This form shows how to edit many-to-many relations with three members.

It places the drop-down lists for the third member in cells. Here is a result of the configuration s02.xl_app_handlers view.

You can find the source codes of the select and change procedures in the code browser below.

Choose an object:

Object definition:

You can download samples for any supported database platform with the SaveToDB SDK.