 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Jürgen Stähr
Guest
|
 Posted: Thu Apr 22, 2004 4:06 pm Post subject: UpdateMode in DataSetProvider |
 |
|
Hi all,
I have a problem with the generated SQL-statements of TDataSetProvider. The
Provider ist connected to a TSQLDataSet and a TClientDataSet is connected to
the Provider as usal.
In the ClientDataSet I have 2 fields marked as key fields (ProviderFlags:
[pfInUpdate,pfInWhere,pfInKey]). The Provider property UpdateMode is set to
upWhereChanged.
But writing back data the update statement generated fromthe Provider do
not include the key fields in the where clause.
Is that an error in TDataSetProvider or have I to set other propertys??
Please Help
Thanks
Juergen Staehr
|
|
| Back to top |
|
 |
Dave Rowntree
Guest
|
| Posted: Thu Apr 22, 2004 4:46 pm Post subject: Re: UpdateMode in DataSetProvider |
|
|
TDataSetProvider is part of MIDAS(datasna) not dbexpress. Questions on
it would normally go in b.p.datasnap or d.p.d.d.multi-tier, whichever
is most appropriate.
"Jürgen Stähr" <Juergen (AT) StaehrNet (DOT) de> wrote:
| Quote: | I have a problem with the generated SQL-statements of TDataSetProvider. The
Provider ist connected to a TSQLDataSet and a TClientDataSet is connected to
the Provider as usal.
In the ClientDataSet I have 2 fields marked as key fields (ProviderFlags:
[pfInUpdate,pfInWhere,pfInKey]).
|
Setting ProviderFlags against a client CDS has absolutely no affect on
anything. You need to set the DSP.DataSet TField ProviderFlags.
Have a look in the NG archives (e.g.www.google.com) for more info on
using ProviderFlags. Doing a search against my name and
'ProviderFlags' probably returns quite a few entries. See if this
helps http://tinyurl.com/yvfqg
--
Dave Rowntree
|
|
| Back to top |
|
|
Jürgen Stähr
Guest
|
| Posted: Tue Apr 27, 2004 7:22 pm Post subject: Re: UpdateMode in DataSetProvider |
|
|
Thank you verry much Dave, I have now set the ProviderFlags in the
SQLDataSet and every thing is working fine.
Juergen Staehr
"Dave Rowntree" <daver (AT) spam_off (DOT) brookswood.co.uk> schrieb im Newsbeitrag
news:o0tf80h8cafnilq0lag0t13vqlg8l15471 (AT) 4ax (DOT) com...
| Quote: | TDataSetProvider is part of MIDAS(datasna) not dbexpress. Questions on
it would normally go in b.p.datasnap or d.p.d.d.multi-tier, whichever
is most appropriate.
"Jürgen Stähr" <Juergen (AT) StaehrNet (DOT) de> wrote:
I have a problem with the generated SQL-statements of TDataSetProvider.
The
Provider ist connected to a TSQLDataSet and a TClientDataSet is connected
to
the Provider as usal.
In the ClientDataSet I have 2 fields marked as key fields (ProviderFlags:
[pfInUpdate,pfInWhere,pfInKey]).
Setting ProviderFlags against a client CDS has absolutely no affect on
anything. You need to set the DSP.DataSet TField ProviderFlags.
Have a look in the NG archives (e.g.www.google.com) for more info on
using ProviderFlags. Doing a search against my name and
'ProviderFlags' probably returns quite a few entries. See if this
helps http://tinyurl.com/yvfqg
--
Dave Rowntree
|
|
|
| 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
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
