![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 11 to 11 of 11 total |
![]() |
Fri, Jan 8 2010 5:22 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Jay,
<< Technically speaking, since SQL has NO natural record order a programmer can rely on, most queries are going to need ORDER BY clause (with or without RANGE). Using "ORDER BY" makes query INSENSITIVE though it may be "Selecting From" only one table and not using no calculated fields. >> Only if you specify an ORDER BY clause that cannot be mapped to an existing index. It is important to get the COLLATE clause correct, also: http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=0&topic=17 Here is a technical article about the collations and grouping/ordering: http://www.elevatesoft.com/articles?action=view&articleno=2 << (1) Any suggestion re: if there is a better way than the approach I am using ? >> Not if the ORDER BY cannot be mapped to an existing index. Do you want the grid to be editable, or is the current design suitable ? -- Tim Young Elevate Software www.elevatesoft.com |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Monday, June 30, 2025 at 12:49 PM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |