strange behavior of TAdodataSet.IndexFieldNames

From: Marek (mark*NOSPAM*_at_tradition.ca)
Date: 10/31/03 

Date: Fri, 31 Oct 2003 00:43:17 -0600

Using TADODataSet I create a recordset by executing the following SQL
statement (against MS SQL 2000):
       select * from MyTable order by Name
my t able has only 4 rows; right after this SQL gets executed, the sequence
of rows (I use DBGrid to see this)
is like this one:
BATCHES
INGR--Y
INGR-77
INGR01
and this is correct [alphabetical] order ( dash chcarcter has lower ASCII
code than 0)
But if I perfrom the following code: TAdodataSet.IndexFieldNames := 'Name
ASC'
the sequence in the DbGrid changes(!), and it looks like this:
BATCHES
INGR01
INGR-77
INGR--Y

is this an error in MS-ADO/MS-OLEDB/Borland-ADOExpress
or perhaps I am not aware about something ?

Thank you very much,
marek

Relevant Pages

  • Re: Millions of Delete Statements
    ... You mention a cursor. ... Others have mentioned batching the commands, ... so I will throw out one that is less good (executing them ... get the whole SQL statement I don't know of another way to do it). ...
    (comp.databases.ms-sqlserver)
  • Re: Poor performance when executing stored procedure
    ... If SQL Server ... has to re-compile the SP, it takes shorter time to compile a smaller stored ... Poor performance when executing stored procedure ...
    (microsoft.public.sqlserver.programming)
  • Re: COBOL stored procedure for DB2
    ... Have you also confirmed that, prior to executing the CALL statement, the ... The DB2 CREATE PROCEDURE statement. ... MODIFIES SQL DATA ... confirm the cob command used for creating the SP module. ...
    (comp.lang.cobol)
  • Re: Oracle11 & statistics calculations
    ... but it did show me that the "counting" SQL is ... elapsed = elapsed time in seconds executing ... user SQL statements in trace file. ... internal SQL statements in trace file. ...
    (comp.databases.oracle.server)
  • Re: Security level to run SP_OA... Procedures
    ... I'm not sure why you are executing sp_OA* procs here since you can ... sp_OA* procs as well as other master database stored procedures. ... Configure the SQL Agent proxy account. ...
    (microsoft.public.sqlserver.security)