Search code examples
mysqldelphizeos

Can we create a virtual table with temporary information from the select command (not other tables)?

I need to fill up a TDBLookupComboBox with the options for a ENUM column:

MOD_MARKETING       ENUM('NENHUMA','CONSULTAR','CADASTRAR','GERENCIAR')

But I do not want to create a new table in the database project just for that. I don't want to use assistant tables. Only tables with the user content.

So, how may I create a temporary virtual table every time I open my application and put those four rows without touch the database structure on the server?

Solution

  • I have found a component called VirtualTable by DevArt.

    It does exactly what I needed.

    http://www.devart.com/vtable/