On 21.08.2011 08:38, edoardo falzetti wrote:
The sql instruction used (which i see in function
TDISQLite3UniDirQuery.PSExecuteStatement) is:
update TableX set Area = ? where Name = ? and Area is null
but this is wrong because Area value is 0 (it has been inserted by
the defalt clause).
DEFAULT values and INTEGER PRIMARY KEYs very much boil down to the same
problem: TDataSetProvider does now know about about any field values
which are automatically inserted by the database engine.
I had never used providers before, i've been studing them now a
little and i've seen that it is possible to let them compose the
istrunction in such way by setting
Provider's TUpdateMode property to UpWhereKeyOnly and by setting
pfInKey in the key Field's ProviderFlag.
Unfortunately this does not help either, because the auto-inserted
INTEGER PRIMARY KEY is still unknown to TDataSetProvider and so the
record will not be found.
What we are looking for is a way to re-read our inserted or modified row
back into our TClientDataSet so we have the auto-filled values available
for the next database operation.
As I have written in my previous message, I believe this is a limitation
of TDataSetProvider and I can unfortunately not not see a simple
solution to it yet. Or am I missing something silly here?
Ralf
_______________________________________________
Delphi Inspiration mailing list
yunqa@xxxxxxxxxxxxx
//www.freelists.org/list/yunqa
