Collapse All Expand All

Syntax

C1Query.SQLInfo.UseIndexInOrderBy= boolean

Notes

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

Description

Specifies whether the SQL dialect supported by the target database allows using names in ORDER BY, as in

SELECT A, B FROM … ORDER BY A, B

or it requires ordinal positions, indexes, as in

SELECT A, B FROM … ORDER BY 1, 2

If this property is set to True, names can be used in ORDER BY.

If this property is set to False, numeric indexes must be used.

See Also

SQL Syntax Properties

 

 

---

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

Product Support Forum  |  Documentation Feedback