Sorting

Article View: borland.public.vdbase.data.sql

Article #649

Back to borland.public.vdbase.data.sql Previous Next

#649

From: Tom Preston
Date: Wed, 29 Jul 1998 00:00

16 lines
800 bytes

Why does a rowset become uneditable when I add a sort to my query?
The following rowset is editable in a grid . . .

SELECT Aropen.CUSNUM, Aropen.INVOICENUM, Aropen.APPLYTO
FROM "aropen.dbf" Aropen
   INNER JOIN "cusmas.dbf" Cusmas
   ON  (Aropen.CUSNUM = Cusmas.CCUSNUM)  

But when I add . . .

ORDER BY Aropen.CUSNUM, Aropen.DUEDATE

I can no longer edit the rowset fields from a grid.

Thanks,
Tom Preston

Technical Details

Message-ID: <35bf44e6.73988884@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,a16be18f543105ea,start
X-Google-Attributes: gidff5a1,public
From: tgp@compuserve.com (Tom Preston)
Subject: Sorting
Date: 1998/07/29
Message-ID: <35bf44e6.73988884@forums.borland.com>
X-Deja-AN: 376989446
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql