BorlandTalk.com Forum Index BorlandTalk.com
Borland discussion newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

SQL query

 
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> comp.lang.pascal.delphi.databases
View previous topic :: View next topic  
Author Message
RY
Guest





PostPosted: Mon Jul 03, 2006 2:16 am    Post subject: SQL query Reply with quote



Hi

I'm a beginner so apologies for this. I want to run an SQL query on a
Paradox database and edit the retrieved fields. When I try to do this with a
basic edit statement I'm told that the dataset is read only. Can someone
help.Many thanks in anticipation

Rod
Back to top
DB-1
Guest





PostPosted: Mon Jul 03, 2006 1:37 pm    Post subject: Re: SQL query Reply with quote



RY wrote:
Quote:

I'm a beginner so apologies for this. I want to run an SQL query on a
Paradox database and edit the retrieved fields. When I try to do this with a
basic edit statement I'm told that the dataset is read only.

It's a question about getting so called 'live' Query result. The
description about the restrictions about live results are listed in
online Help under title "Obtaining an editable result set".

Unfortunately Windows Help System usually is not so willing to serve
that you could just type that search phrase anywhere inside the Delphi
online help (consisting about 40 different .HLP files), and it would
lead you straight to this page.
Depending on your Delphi version, you better try first to locate the
Del6Dbd.HLP Help file (=Delphi-6 version), and seek the 'Obtaining..'
keyword from there.

For more advanced DB development and usage you may also check what
services the TUpdateSql component may bring to you.
DB-1
Back to top
Display posts from previous:   
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> comp.lang.pascal.delphi.databases All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.