Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 11 of 11 total
Thread Conversion DBISAM to ElevateDB
Fri, Jan 8 2010 5:22 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PagePage 2 of 2
Jump to Page:  1 2
Image