Re: Join and Copy?

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

Article #1390

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

#1390

From: Rick Fath
Date: Wed, 14 Jan 1998 00:00

28 lines
1295 bytes

Charles,

the error I get is  "Database Engine Error: table is read only"

I finally got the copy to work  with code using the class updateset.  the
key is to set the property "requestLive=false" in the query object. I guess
the sort option on the menu
uses the default of "requestLive=true" ?

thanks Rick




charles richards wrote:

> Rick Fath wrote in message <34BCBDAE.C47234DF@hotmail.com>...
> >I'm am doing a left outer join on two remote sybase tables which works
> >fine, but I cannot sort the result set to local table?
>
> Rick,
>
> What is the error message when you try to sort the tables? If you have a
> sort (order by) in your sql code, then you have to sort on something
> different when you copy to a local table.
>
> Charles Richards

Technical Details

Message-ID: <34BD8BCD.B469A581@hotmail.com>

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

References: <34BCBDAE.C47234DF@hotmail.com> <69it72$ck213@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,3375d1a790f363f2
X-Google-Attributes: gidff5a1,public
From: Rick Fath <rfath@hotmail.com>
Subject: Re: Join and Copy?
Date: 1998/01/14
Message-ID: <34BD8BCD.B469A581@hotmail.com>
X-Deja-AN: 316069687
Content-Transfer-Encoding: 7bit
References: <34BCBDAE.C47234DF@hotmail.com> <69it72$ck213@forums.borland.com>
Content-Type: text/plain; charset=us-ascii
Organization: None
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message