DBGate Sample 16 - Symbol Lists

This sample demonstrates how to create forms for managing many-to-many relationships.

Symbol Lists

Consider a table of stock lists, such as s16_list_symbols. Using a form like the one below is much more effective.

You can use the spacebar to create or delete pairs.

This feature has a unique aspect. The s02.xl_app_handlers defines the BitColumn type for list columns. HereвЂ™s a view of the result.

This form illustrates how to edit many-to-many relationships involving three members.

It places drop-down lists for the third member in individual cells. HereвЂ™s a result from the configuration view of s02.xl_app_handlers.

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

Choose an object:

Object definition:

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