RE: commitupdates doesn't reset updatestatus

This message is in MIME format. Since your mail reader does not 
understand this format, some or all of this message may not be legible.
--JivePart=_ab1de.zeB8CwDOH5aMJzMl
Content-Type: text/plain; charset="Utf-8"

--
-- 
With best regards,
Dmitry Arefiev / FireDAC Architect

--JivePart=_ab1de.zeB8CwDOH5aMJzMl
Content-Type: text/plain;
  name="internal_calc.patch"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
  filename="internal_calc.patch"

SW5kZXg6IEZpcmVEQUMuRGF0Uy5wYXMNCj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0NCi0tLSBGaXJlREFDLkRhdFMucGFz
CShyZXZpc2lvbiA4MDMzNSkNCisrKyBGaXJlREFDLkRhdFMucGFzCSh3b3JraW5nIGNvcHkpDQpA
QCAtOTU1NCw5ICs5NTU0LDE3IEBADQogICAgIGVuZA0KICAgICBlbHNlIGlmIFJvd1ByaW9yU3Rh
dGUgPSByc1VuY2hhbmdlZCB0aGVuIGJlZ2luDQogICAgICAgQ2hlY2tSb3dDb25zdHJhaW50cyhy
c01vZGlmaWVkKTsNCi0gICAgICBGcEN1cnJlbnQgOj0gRnBQcm9wb3NlZDsNCi0gICAgICBGcFBy
b3Bvc2VkIDo9IG5pbDsNCi0gICAgICBGUm93U3RhdGUgOj0gcnNNb2RpZmllZDsNCisgICAgICBp
ZiBub3QgQU5vVmVyc2lvbiB0aGVuIGJlZ2luDQorICAgICAgICBGcEN1cnJlbnQgOj0gRnBQcm9w
b3NlZDsNCisgICAgICAgIEZwUHJvcG9zZWQgOj0gbmlsOw0KKyAgICAgICAgRlJvd1N0YXRlIDo9
IHJzTW9kaWZpZWQ7DQorICAgICAgZW5kDQorICAgICAgZWxzZSBiZWdpbg0KKyAgICAgICAgRnJl
ZUJ1ZmZlcihGcE9yaWdpbmFsKTsNCisgICAgICAgIEZwT3JpZ2luYWwgOj0gRnBQcm9wb3NlZDsN
CisgICAgICAgIEZwUHJvcG9zZWQgOj0gbmlsOw0KKyAgICAgICAgRlJvd1N0YXRlIDo9IHJzVW5j
aGFuZ2VkOw0KKyAgICAgIGVuZDsNCiAgICAgICBOb3RpZnkoc25Sb3dTdGF0ZUNoYW5nZWQsIHNy
RGF0YUNoYW5nZSwgTmF0aXZlSW50KFNlbGYpLCAwKTsNCiAgICAgICBpZiBub3QgQU5vVmVyc2lv
biB0aGVuDQogICAgICAgICBSZWdpc3RlckNoYW5nZTsNCg==

--JivePart=_ab1de.zeB8CwDOH5aMJzMl--

0
Dmitry
5/29/2015 7:41:45 AM
embarcadero.attachments 933 articles. 0 followers. Follow

2 Replies
469 Views

Similar Articles

[PageSpeed] 21

I might need this patch as well, but I don't think I'm using internalCalcs. I have a standard calculated field. I have code...

if updatesPending then applyUpdates;

The applyUpdates works, but updatesPending remains true. Should I apply the patch to see if it fixes my problem?

Here is my dataset, much deleted to just show what I think is relevant:

object SPReceiptLI: TFDStoredProc
  OnCalcFields = SPReceiptLICalcFields
  CachedUpdates = True
  UpdateOptions.AssignedValues = [uvUpdateMode]
  UpdateOptions.UpdateMode = upWhereChanged
  UpdateOptions.UpdateTableName = 'SPIDPOReceiptCostItem'
  UpdateOptions.KeyFields = 'ID'
  StoredProcName = 'JCSPDEGetPOReceiptItems'
  object SPReceiptLIID: TFDAutoIncField
    FieldName = 'ID'
    Origin = 'ID'
    ProviderFlags = [pfInWhere, pfInKey]
    ReadOnly = True
  end
  object SPReceiptLIDescriptionFmt: TBlobField
    DisplayLabel = 'Description'
    FieldName = 'DescriptionFmt'
    Origin = 'DescriptionFmt'
    Size = 2147483647
  end
  object SPReceiptLIReceivedAllOtherLI: TFloatField  // I show this b/c the query calculates this field, it is not from the base table
    DisplayLabel = 'Recd Other'
    FieldName = 'ReceivedAllOtherLI'
    Origin = 'ReceivedAllOtherLI'
    DisplayFormat = '#.00'
  end
  object SPReceiptLIQuantityBO: TFloatField  // this is the calculated field
    DisplayLabel = 'Back Ordered'
    FieldKind = fkCalculated
    FieldName = 'QuantityBO'
    DisplayFormat = '#.00'
    Calculated = True
  end
end


> {quote:title=Dmitry Arefiev wrote:}{quote}
> --
> -- 
> With best regards,
> Dmitry Arefiev / FireDAC Architect
0
Keith
6/5/2015 2:17:01 PM
Or perhaps my problem is I'm new to cached updates... I use ApplyUpdates. Should I use CommitUpdates?

> {quote:title=Dmitry Arefiev wrote:}{quote}
> --
> -- 
> With best regards,
> Dmitry Arefiev / FireDAC Architect
0
Keith
6/5/2015 2:18:09 PM
Reply:

Similar Artilces:

commitupdates doesn't reset updatestatus
Isn't commitupdates supposed to reset updatestatus? I have code like this {code} with Query do begin Close; DisableControls; OnCalcFields := QueryCalcFields; Params[0].AsString := 'midata'; Open; OnCalcFields := nil; // to be sure that all records will be unmodified CommitUpdates; EnableControls; First; while not eof do begin if Query.UpdateStatus <> usUnModified then showmessage('bug??'); Next; end; end; {code} It shows the mes...

superreview granted: [Bug 245619] Don't bother converting result of scripts into a string when the caller doesn't care about the value. : [Attachment 150056] Don't convert the result to a string if t
Brendan Eich <brendan@mozilla.org> has granted Johnny Stenback <jst@mozilla.jstenback.com>'s request for superreview: Bug 245619: Don't bother converting result of scripts into a string when the caller doesn't care about the value. http://bugzilla.mozilla.org/show_bug.cgi?id=245619 Attachment 150056: Don't convert the result to a string if the caller doesn't care about the return value. http://bugzilla.mozilla.org/attachment.cgi?id=150056&action=edit ------- Additional Comments from Brendan Eich <brendan@mozilla.org> Duh, thanks. r+sr=me....

superreview requested: [Bug 122238] input type="image" doesn't send x/y (image doesn't exist; width and height not set) : [Attachment 139545] Same as jkeiser's patch, really...
Boris Zbarsky <bz-vacation@mit.edu> has asked Johnny Stenback <jst@mozilla.jstenback.com> for superreview: Bug 122238: input type="image" doesn't send x/y (image doesn't exist; width and height not set) http://bugzilla.mozilla.org/show_bug.cgi?id=122238 Attachment 139545: Same as jkeiser's patch, really... http://bugzilla.mozilla.org/attachment.cgi?id=139545&action=edit ...

superreview granted: [Bug 122238] input type="image" doesn't send x/y (image doesn't exist; width and height not set) : [Attachment 139545] Same as jkeiser's patch, really...
Johnny Stenback <jst@mozilla.jstenback.com> has granted Boris Zbarsky <bz-vacation@mit.edu>'s request for superreview: Bug 122238: input type="image" doesn't send x/y (image doesn't exist; width and height not set) http://bugzilla.mozilla.org/show_bug.cgi?id=122238 Attachment 139545: Same as jkeiser's patch, really... http://bugzilla.mozilla.org/attachment.cgi?id=139545&action=edit ------- Additional Comments from Johnny Stenback <jst@mozilla.jstenback.com> + if (!name.IsEmpty()) { + aFormSubmission->AddNameValuePair(thi...

Re: INSTALLSCRIPT doesn't have 'site', 'vendor' values?
On Tue, 05 Nov 2002 01:54:22 GMT, ken@mathforum.org (Ken Williams) wrote in news:814B3DD1-F061-11D6-AADE-003065F6D85A@mathforum.org: > Hi, > > I notice the following in the MakeMaker docs (version 5.91_01): Just FYI, ExtUtils::MakeMaker is up to current v 6.05 now. It is an easy upgrade to do manually. > I'm curious about why INST_SCRIPT doesn't have different values in the > three columns. Is this why things like LWP's "HEAD" script are > installing to /usr/bin on OS X instead of to /usr/local/bin? I recently noticed this too. My g...

superreview requested: [Bug 245619] Don't bother converting result of scripts into a string when the caller doesn't care about the value. : [Attachment 150056] Don't convert the result to a string if
Johnny Stenback <jst@mozilla.jstenback.com> has asked Brendan Eich <brendan@mozilla.org> for superreview: Bug 245619: Don't bother converting result of scripts into a string when the caller doesn't care about the value. http://bugzilla.mozilla.org/show_bug.cgi?id=245619 Attachment 150056: Don't convert the result to a string if the caller doesn't care about the return value. http://bugzilla.mozilla.org/attachment.cgi?id=150056&action=edit ...

superreview granted: [Bug 232129] imap protocol logging doesn't handle long lines : [Attachment 139853] fix that doesn't add newlines
Scott MacGregor <mscott@mozilla.org> has granted David Bienvenu <bienvenu@nventure.com>'s request for superreview: Bug 232129: imap protocol logging doesn't handle long lines http://bugzilla.mozilla.org/show_bug.cgi?id=232129 Attachment 139853: fix that doesn't add newlines http://bugzilla.mozilla.org/attachment.cgi?id=139853&action=edit ------- Additional Comments from Scott MacGregor <mscott@mozilla.org> cool. thanks for the clarification. ...

superreview requested: [Bug 232129] imap protocol logging doesn't handle long lines : [Attachment 139853] fix that doesn't add newlines
David Bienvenu <bienvenu@nventure.com> has asked Scott MacGregor <mscott@mozilla.org> for superreview: Bug 232129: imap protocol logging doesn't handle long lines http://bugzilla.mozilla.org/show_bug.cgi?id=232129 Attachment 139853: fix that doesn't add newlines http://bugzilla.mozilla.org/attachment.cgi?id=139853&action=edit ...

superreview granted: [Bug 327738] Reset Camino doesn't reset minimized windows. : [Attachment 226018] Patch
Simon Fraser <sfraser_bugs@smfr.org> has granted superreview: Bug 327738: Reset Camino doesn't reset minimized windows. https://bugzilla.mozilla.org/show_bug.cgi?id=327738 Attachment 226018: Patch https://bugzilla.mozilla.org/attachment.cgi?id=226018&action=edit ...

superreview requested: [Bug 87513] about:<randomness> doesn't display a default page, if the about: topic doesn't exist. : [Attachment 195365] Simple fix
Boris Zbarsky <bzbarsky@mit.edu> has asked Darin Fisher <darin@meer.net> for superreview: Bug 87513: about:<randomness> doesn't display a default page, if the about: topic doesn't exist. https://bugzilla.mozilla.org/show_bug.cgi?id=87513 Attachment 195365: Simple fix https://bugzilla.mozilla.org/attachment.cgi?id=195365&action=edit ...

superreview granted: [Bug 87513] about:<randomness> doesn't display a default page, if the about: topic doesn't exist. : [Attachment 195365] Simple fix
Darin Fisher <darin@meer.net> has granted Boris Zbarsky <bzbarsky@mit.edu>'s request for superreview: Bug 87513: about:<randomness> doesn't display a default page, if the about: topic doesn't exist. https://bugzilla.mozilla.org/show_bug.cgi?id=87513 Attachment 195365: Simple fix https://bugzilla.mozilla.org/attachment.cgi?id=195365&action=edit ------- Additional Comments from Darin Fisher <darin@meer.net> sr=darin ...

superreview granted: [Bug 271815] GTK2 IM over-the-spot doesn't work with Chinese IM because the editor doesn't return correct caret position : [Attachment 226123] Patch rv1.2
Masayuki Nakano (Mozilla Japan) <masayuki@d-toybox.com> has granted Masayuki Nakano (Mozilla Japan) <masayuki@d-toybox.com>'s request for superreview: Bug 271815: GTK2 IM over-the-spot doesn't work with Chinese IM because the editor doesn't return correct caret position https://bugzilla.mozilla.org/show_bug.cgi?id=271815 Attachment 226123: Patch rv1.2 https://bugzilla.mozilla.org/attachment.cgi?id=226123&action=edit ...

superreview requested: [Bug 271815] GTK2 IM over-the-spot doesn't work with Chinese IM because the editor doesn't return correct caret position : [Attachment 223809] Patch rv1.1
Masayuki Nakano (Mozilla Japan) <masayuki@d-toybox.com> has asked Robert O'Callahan (Novell) <roc@ocallahan.org> for superreview: Bug 271815: GTK2 IM over-the-spot doesn't work with Chinese IM because the editor doesn't return correct caret position https://bugzilla.mozilla.org/show_bug.cgi?id=271815 Attachment 223809: Patch rv1.1 https://bugzilla.mozilla.org/attachment.cgi?id=223809&action=edit ...

superreview cancelled: [Bug 271815] GTK2 IM over-the-spot doesn't work with Chinese IM because the editor doesn't return correct caret position : [Attachment 223809] Patch rv1.1
Masayuki Nakano (Mozilla Japan) <masayuki@d-toybox.com> has cancelled Masayuki Nakano (Mozilla Japan) <masayuki@d-toybox.com>'s request for superreview: Bug 271815: GTK2 IM over-the-spot doesn't work with Chinese IM because the editor doesn't return correct caret position https://bugzilla.mozilla.org/show_bug.cgi?id=271815 Attachment 223809: Patch rv1.1 https://bugzilla.mozilla.org/attachment.cgi?id=223809&action=edit ...

Web resources about - RE: commitupdates doesn't reset updatestatus - embarcadero.attachments

Resources last updated: 12/1/2015 9:07:40 PM