Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 11 to 11 of 11 total |
Conversion DBISAM to ElevateDB |
Fri, Jan 8 2010 5:22 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 Sunday, May 5, 2024 at 10:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |