Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi

I apologize in advance if I understand something wrong (language problem?) But for me the answer to the question:

I have found the syntax SELECT ... INTO CACHED FOO will this have the desired effect? Or will it create some kind of materialised View... ?

The answer is yes, you can use this syntax.

A new table is created (however it will be necessary to refresh the list of tables: ViewRefresh Tables). It is not a view.

The limit is that the table is the result of a SELECT with all the induced limits: no primary key creation, no recovery of all the attributes (default values ...). You can of course modify later if necessary (ALTER)

So, with ToosSQLyou can execute something like:

SELECT "Name", "LastName"  INTO  CACHED "New" FROM "Clients"

Regards