Testing Driver Capabilities

Testing Driver Capabilities
This driver is not guaranteed to work with all possible front-end ODBC applications, and it would be impossible to test them all. If you find you have problems with this driver that do not occur in other ODBC drivers, contact your dealer or FLEXquarters. We do want to provide maximum compatibility wherever possible.

A simple Visual Basic test program called VBDEMO.EXE has been included in this product to allow basic testing and to isolate problems from various environments. Once loaded, clicking on the "Tables" button should produce a list from FILELIST.CFG, and entering SELECT * FROM FLEXERRS and clicking the "Query" button should show records of data from this standard DataFlex Error file.

Here are some other SQL statement examples to try:

1.Select the courses, their departments and number of credits for each:
SELECT course_name, department, num_credits FROM COURSES
2.Select the course and the number of credits for all courses with 3 credits:
SELECT course_name, num_credits FROM COURSES WHERE num_credits = 3
3.Select the names and addresses of all the female students from Chicago or Atlanta:
SELECT student_name, address, city, state FROM STUDENTS WHERE city IN ( 'CHICAGO', ATLANTA) and sex = 'F'
4.Select the names & phone numbers of teachers whose phone numbers don't begin with 257:
SELECT teacher_name, phone FROM TEACHERS WHERE phone not like '257%'
5.Select all the credit courses having less than 3 credits alphabetically by department:
SELECT department, course_name FROM COURSES WHERE num_credits <3 ORDER BY department
6.Select the largest salary paid to a teacher:
SELECT MAX(salary) FROM TEACHERS
7.Select teachers who teach each course:
SELECT teacher_name, SECTIONS.teacher, course FROM TEACHERS, SECTIONS WHERE TEACHERS.teacher = SECTIONS.teacher
8.Select teachers and the course names and numbers they teach:
SELECT teacher_name SECTIONS.course, course_name FROM TEACHERS, SECTIONS, COURSES WHERE TEACHERS.teacher = SECTIONS.teacher AND SECTIONS.course = COURSES.COURSE
9.Select all fields of customers in state of CA:
SELECT * FROM CUSTOMER WHERE STATE = 'CA'
10.Select all fields of customers by name index:
SELECT * FROM CUSTOMER ORDER BY NAME
11.Change time zone of records in region W to 4:
UPDATE CUSTOMER SET TIMEZONE = 4 WHERE REGION = 'W'
12.Add a new record into customer file:
INSERT INTO CUSTOMER(NAME,STATE) VALUES('BILL','OK')
13.Delete records from customer file when last invoice older than May 5, 1993:
DELETE FROM CUSTOMER WHERE LAST_INVOICE <-d '1993-05-05'd

Use an SQL reference manual for further details on syntax and options.

VB Demo

To establish a connection: From the menu bar select "Connection" / "Add a new connection ", select the Data Source you want, Click "OK", an established connection to your data source message appears, Click "OK", type in your SQL query, Click "Query" button and VOILA, the requested query results will appear.

To disconnect, you can either select "connections" / "remove the connection" or Click the "disconnect" button.

VB Demo

C++ Demo

An additional program CPPDEMO.EXE has been included to show that a C++ program accessing data from different records in different files in a DataFlex database via the ODBC driver is much faster than Visual Basic or MS Access.

To establish a connection : From the menu bar select "Environment" / "Open connection", select the Data Source you want, Click "OK", Select "SQL" / "Execute SQL" from the menu bar, type in your SQL query, Click "OK" and VOILA, the requested query results will appear.

C++ Demo