Using Data Access Pages to Access Data on a SQL Anywhere 10 Database - Importing the Customers Table
(Page 3 of 4 )
When you click OK to the above screen, the program pauses and the Import Objects window of the MS Access application shows up, displaying the various tables that you may want to import. Highlight Group0.Custormers and click on the button labeled OK.
The Group0.Customers table is added to the TestXML database as shown. The Group0.Customers table was renamed to Demo10_Customers.
The next window shows some sample data from this table.
Creating a Query for the Data Access Page
The data access page will be based on a query of this table. The query used is shown in the next paragraph. This may also be designed using the MS Access query designer. The query selects several columns and later orders them by the column "State." The query is given the default name Demo10_Customers Query.
SELECT Dem10_Customers.ID,
Dem10_Customers.Surname,
Dem10_Customers.GivenName,
Dem10_Customers.City,
Dem10_Customers.State,
Dem10_Customers.Country
FROM
Dem10_Customers
ORDER BY
Dem10_Customers.State;
Next: Creating a Data Access Page >>
More Database Articles
More By Jayaram Krishnaswamy
