ComponentOne Query 8.0
Syntax Property

Syntax

C1Query.SQLInfo.Syntax= value

Notes

Read/Write at run time. Unavailable at design time. Property applies to SQLInfo object.

Values

Constant Value and Name

Meaning

0 – c1qSQL2

SQL2 standard: JOIN keyword supported

1 – c1qSQL1

SQL1 standard: no JOIN, no outer joins

2 – c1qOracle

Oracle dialect: no JOIN, outer join supported

Description

This property sets/returns the SQL dialect of the target database.

See Also

SQL Syntax Properties

 

 


Copyright (c) GrapeCity, inc. All rights reserved.

Product Support Forum  |  Documentation Feedback