You may not be authorized to see this content. Please contact Data Access Europe for more information.

Cancel Data Access Europe

You are not authorized to see this content.

Cancel Data Access Europe

Build your own Search Engine

39m 33s

Advanced

In modern applications it's important that users can find data by typing in keywords. The entered keywords should search through one table, multiple tables or maybe even multiple tables that are not even related to each other. This Course shows how to build such a Search engine using the DataFlex Web App Framework.

Start course

Introduction to the Course.

Creating a view for use in DataFlex using SQL Server Management Studio

Using an SQL database backend will result in a better performance of the application, because the searches will be done on the SQL Server. The technique used is called `database views'. This lesson shows the advantages of database views and how to build a database view.

Making a data source sortable by specific column indexes

The previous lesson showed how to create database views. DataFlex sees those views as tables. Creating column indexes to the table allows to sort on those indexes in the application. This lesson shows how to integrate the created database views into DataFlex and how to create indexes.

How to create select type and zoom views

All columns of a view can be viewed in a list, or Select Type of view. This lesson shows how to create a Select View using the wizard.

Making a view's columns sortable

The previous lesson showed a list of all the columns: track name, album title and track artist. This lesson shows how to make it possible to sort on the various columns.

Adding a search field to a view

The user should be able to type in a search value and search through all the columns (track name, album title and track list). This lesson shows how to add a search field to a view.

Building a Search Engine

A search engine basically combines a number of result sets and presents them as a single, searchable result set. This lesson focuses on building a search engine with DataFlex.

Course instructor

Eddy Kleinjan

Technical Director, Data Access Europe B.V.