Value Lists with DBGate

DBGate supports several configurations for value lists:

• Validation Lists
• Selection Lists
• Parameter Values
• Value Lists with Fixed Values
• Value Lists Using Tables and Views
• Value Lists Using Stored Procedures
• Value Lists Using SQL

DBGate automatically generates the necessary API, publishing the configured properties in the object metadata.

You can explore online samples here:

• https://dbgate.savetodb.com/api/mssql-023/en-us/s02/cashbook/$metadata
• https://dbgate.savetodb.com/api/mssql-023/en-us/s02/view_cashbook/$metadata
• https://dbgate.savetodb.com/api/mssql-023/en-us/s02/usp_cashbook/$metadata

The built-in JavaScript client and SaveToDB 8+ support these features out of the box.