 |
BorlandTalk.com Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
RY Guest
|
Posted: Mon Jul 03, 2006 2:16 am Post subject: SQL query |
|
|
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
|
Posted: Mon Jul 03, 2006 1:37 pm Post subject: Re: SQL query |
|
|
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 |
|
 |
|
|
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
|
|