Click above to get retro games delivered to your door ever month!

 What is SQL ?
--------------------------------------------------------------------------------

   Microsoft Windows has chosen SQL as the standard method to manage ODBC
   drivers. SQL is the programming system to manage ODBC architecture.

   SQL means Structured Query Language, and in some aspects it is very
   similar to what we are used to with Clipper and xBase dialects.

   There are different levels of SQL, according to SQL historic evolution.
   Right now we may find:

                           SQL - core level
                           SQL - Level 1
                           SQL - Level 2

   The core level is the most basic and standard system. All ODBC drivers
   accept most of SQL core level rules. Level1 and Level2 offer more
   powerful capabilities. The first thing you need to identify when using
   an ODBC driver is exactly at which level it operates. ODBC driver
   manufacturers may provide an extensive documentation and samples.

   Some drivers DON'T accept all ODBC capabilities. Carefully review your
   ODBC driver documentation to learn its capabilities.

   SQL is managed using functions and SQL commands.

   SQL functions are managed in the same way as we manage Clipper functions.
   They are just functions.

   SQL commands are strings which contains a SQL statement to be executed:

   Sample:

              "SELECT * FROM Dialog"


   To execute this statement, we use it as an argument to a function call:

           SQLExecDirect( ..., "SELECT * FROM ..." )


   FiveWin offers an ODBC Class that automatically does all these in a
   very easy way.