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 may 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.

Scheduled Lists

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 may find the source codes of the select and change procedures in the code browser below.

Code Browser

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