Previous Topic

Next Topic

Minimum SQL Grammar

The minimum Grammar requirements (fully met by the c-tree ODBC Driver) are as follows:

  • Create Table
  • Delete (searched)
  • Drop Table
  • Insert
  • Select
  • Update (searched)

The following tables provides some examples of the minimum SQL grammar supported by the FairCom ODBC Driver:

Grammar

Examples

Comments

CREATE TABLE

CREATE TABLE sal (emp_id integer, name char(50), salary float, hire_date date)

CREATE TABLE emp (emp_id integer NOT NULL, PRIMARY KEY (emp_id) )

Column constraint definitions supported: NOT NULL.

Table constraint definitions supported: UNIQUE and PRIMARY KEY DEFAULT. Default-value is not sup

DELETE

DELETE FROM sal WHERE name = ‘John Smith’

 

DROP TABLE

DROP TABLE sal

[CASCADE | RESTRICT] is not supported.

INSERT

INSERT INTO sal VALUES (34086, ‘Fred Black’, 45000.00, ‘1992-05-25’)

 

SELECT

SELECT * FROM sal

SELECT emp.emp_id, sal.salary FROM emp, sal WHERE emp.emp_id = sal.emp_id

 

UPDATE

UPDATE sal SET salary = 35000.00 WHERE emp_id = 25089