Re: rowset uneditable when I use the ORDER BY clause?

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

Article #56

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

#56

From: Michelle Sintov
Date: Wed, 25 Feb 1998 00:00

22 lines
1372 bytes

I too discovered this last week.  In order to edit the rowset, since I am
only adding records, I deactivate the query prior to editing the table,
change the sql (removing the order by clause), activate the table, add the
new records, save the records, then deactivate the table so I can change the
sql and add the order by clause again.

- Michelle

Paul Lin wrote in message <34EB5CF4.CA22D46D@davd.com>...
>When I use an "ORDER BY" clause in my sql statement, the resulting
>rowset from the query object (dBASE) becomes uneditable (error: rowset
>is read only).  I've tried calling the beginEdit() function and setting
>autoedit property to true, which didn't help.  I can't use indices
>because the order criteria is to be specified at runtime.  Does anyone
>have other ideas?
>
>thanks in advance,
>
>Paul Lin
>Davidson & Associates
>

Technical Details

Message-ID: <6d1t0i$37c9@forums.borland.com>

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

References: <34EB5CF4.CA22D46D@davd.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101d9a,e3d4b72e3c936645
X-Google-Attributes: gid101d9a,public
From: "Michelle Sintov" <removethismichelle@viewnetinc.com>
Subject: Re: rowset uneditable when I use the ORDER BY clause?
Date: 1998/02/25
Message-ID: <6d1t0i$37c9@forums.borland.com>
X-Deja-AN: 328602842
References: <34EB5CF4.CA22D46D@davd.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: VIEWnet, Inc.
Newsgroups: borland.public.intrabuilder.data.sql

Reply to Parent Message