search

pashagolub / postgresdac

Delphi/C++Builder direct access components for PostgreSQL (and derivatives)
MIT License
19 stars 12 forks source link

Access TField->OldValue via PSQLQuery #21

Closed PinkyFox1984 closed 5 months ago

PinkyFox1984 commented 5 months ago

Hellow. When I try to access TField->OldValue from PSQLQuery it alway undefind TField->NewValue always have actual data - on Open() its from db, after edited. CachedUpdates = true

pashagolub commented 5 months ago

Hi.

It's valid only during editing.

PinkyFox1984 commented 5 months ago

I find the problem. It depend of FieldName case. in db "username", in TField->FieldName='USERNAME'. PSQLQuery1->FieldByName("USERNAME")->OldValue --- undefined when TField->FieldName='username'. PSQLQuery1->FieldByName("USERNAME")->OldValue --- filled whith correct value.