ADO Sort Property, please help.

Thread View: borland.public.cppbuilder.database.ado

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Oleg Tue, 16 Jan 2001 02:51

#5927

Author: Oleg
Date: Tue, 16 Jan 2001 02:51

24 lines
1442 bytes

Hi all
I open query like

"select * from books"
(server if MSSQL 7.0)

then inside the code trying to ADOQuery->Sort = "AUTHOR" // one of the
field;
and it's tell's me "Object or provider is not capable of perfoming requested
operation"

Is Anyone can help me with this ?
Hi all
I open query like

"select * from books"
(server if MSSQL 7.0)

then inside the code trying to ADOQuery->Sort = "AUTHOR" // one of the
field;
and it's tell's me "Object or provider is not capable of perfoming requested
operation"

Is Anyone can help me with this ?

Re: ADO Sort Property, please help.

#5928

Author: Peter Dragun
Date: Mon, 15 Jan 2001 23:58

22 lines
1425 bytes

You may want to let the SQL statement do the work.

e.g.
SELECT * FROM Books ORDER BY Author ASC




"Oleg" <oleg@sequoiap.com> wrote in message news:3a63b8a4$1_1@dnews...
> Hi all
> I open query like
>
> "select * from books"
> (server if MSSQL 7.0)
>
> then inside the code trying to ADOQuery->Sort = "AUTHOR" // one of the
> field;
> and it's tell's me "Object or provider is not capable of perfoming
requested
> operation"
>
> Is Anyone can help me with this ?

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads