Foros Club Delphi - Vista de tablas de PARADOX

Foros Club Delphi (https://www.clubdelphi.com/foros/index.php)

- Conexión con bases de datos (https://www.clubdelphi.com/foros/forumdisplay.php?f=2)

- - Vista de tablas de PARADOX (https://www.clubdelphi.com/foros/showthread.php?t=49331)

Vista de tablas de PARADOX

Buen dia.

Se puede hacer vistas de tablas de Paradox, para no trabajar directamente con las tablas de mi base de datos.

ATTE

Joseph Obando:rolleyes:

Si se pueden crear:

Cita:

CREATE VIEW

See also

A view creates a virtual table from a SELECT statement. You can look at just the data you need within this movable frame or window on the table, while the technical underpinnings are hidden. Instead of entering a complex qualified SELECT statement, the user simply selects a view.
CREATE VIEW describes a view of data based on one or more underlying tables in the database. The rows to return are defined by a SELECT statement that lists columns from the source tables. A view does not directly represent physically stored data. It is possible to perform select, project, join, and union operations on views as if they were tables.

CREATE VIEW enables users to create views on tables by using the following syntax:

CREATE VIEW view_name [ (column_name [, column_name]...)]

CREATE VIEW is supported in conjunction with the Client Data Repository (CDR). The CDR stores the SELECT statement that defines the view.
The "WITH CHECK OPTION" is supported to create a constrained view.
Views of Views are supported. However, the CASCADE/LOCAL view attribute is not supported, because all updateable views CASCADE the constraints.

Un Saludo.

Marcos te la sabes todas en Paradox :D:D

Esa vista no se crea en la bd?? o solo cuando se va a ejecutar la consulta???:confused::confused:

Pido perdon por asumir en el hilo anterior que no se podia esto es nuevo para mi tendre mas cuidado antes de responder algo asi

Me puedes hacer un ejempo en codigo de Delphi para que me quede un poco mas claro.

Atte

Joseph Obando