🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #5928

Re: ADO Sort Property, please help.

#5928
From: 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 ?
Technical Details
Message-ID: <3a63d541$1_2@dnews>
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!cyclone-sjo1.usenetserver.com!news-out.usenetserver.com!newsfeed.wirehub.nl!news.maxwell.syr.edu!newsfeed1.uni2.dk!newssuck.uni2.dk!bornews.borland.com!dnews!24.141.90.110
References: <3a63b8a4$1_1@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,123844dd494aae78
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-01-15 21:04:01 PST
Reply-To: "Peter Dragun" <pdragun@home.com>
From: "Peter Dragun" <pdragun@home.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3a63b8a4$1_1@dnews>
Subject: Re: ADO Sort Property, please help.
Date: Mon, 15 Jan 2001 23:58:56 -0000
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 24.141.90.110
Message-ID: <3a63d541$1_2@dnews>
X-Trace: 15 Jan 2001 20:59:45 -0800, 24.141.90.110
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!cyclone-sjo1.usenetserver.com!news-out.usenetserver.com!newsfeed.wirehub.nl!news.maxwell.syr.edu!newsfeed1.uni2.dk!newssuck.uni2.dk!bornews.borland.com!dnews!24.141.90.110