General SQL Parser -> How to

Installation
   Just copy all dcu files to a directory. And make this directory in the search path of your project options.(Project->Options->Directories/Conditionals->Search path).

Getting started
   Check demo application shipped with Gsqlparser to see how to use TGSqlparser.

DLL Library
   If you use other programming language other than delphi such as VB, VC++ then you can use DLL library in your program. There are 5 functions include in this library.
   1. ParseSql, parse SQL statements and send result back to caller.
   2. GetOutputSql, if there are no syntax errors in SQL statements, then use this function to get formatted SQL statements.
   3. GetOutputMsg, if there are syntax errors in SQL statements, then use this function to get error messages.
   4. FreeParser, release the resource allocated by ParseSql.
   5. SetCheckSyntaxOnly, set whether check syntax of SQL statements only.
    For more details information of how to use DLL library, please check the included demos.

Command Line Program
   This is another way to use General SQL Parser, this stand alone program accept SQL file as input parameter and generate formatted SQL file or Error message file if there are any syntax errors in inputted SQL file.

    Gsqlparsercmd -I input.sql -o output.fmt -e output.err

    Gsqlparsecmd checks the syntax of SQL statements in input.sql, if there is no errors in this file, then all SQL statements will be formatted and save in output.fmt. If there are any syntax errors, all this error messages will be save in output.err.
   In this example, input.sql, output.fmt and output.err will all be located in the same directory of gsqlparsercmd.