How to create a view in Paradox ?

How to create a view in Paradox ?

2001-04-27 19:31:52


create a view on Paradox or any other standard table, do the following. Write the SQL statement whose result you want to query in a .SQL file and place the file into the data folder. e.g. create a file called view.sql with the following content



SELECT ORD.OrderNo , CUST.Company , EMP.FirstName , EMP.LastName
FROM CUSTOMER CUST , ORDERS ORD , EMPLOYEE EMP
WHERE CUST.CustNo = ORD.CustNo AND EMP.EmpNo = ORD.EmpNo



Here I have taken the tables from DBDEMOS alias. Save the file in the directory where DBDEMOS points to. Then you can write a query like this in your application


select *
from "view.sql"
order by FirstName, LastName T


his way one can create an equivalent of a view in Paradox. The advantages of this are enormous.