Subject | POST vs UPDATE in TIBOQuery dataset |
---|---|
Author | Chuck Belanger |
Post date | 2001-09-26T16:15:47Z |
Hello:
Hoping someone can help me to understand something (I'm still very new
to IBO, IB and Delphi):
Using IBO: TIBOQuery component with Woll2Woll components, but because
there was no Tww checkbox, I used a LED and its ONCLICK event to change
and show the state of a Boolean field. I'm using this in conjunction
with their dbTreeView and everything works fine, except when I want to
update the field, initially I tried to edit, getfieldbyname, post which
did not update the underlying datasource, and caused the display to
point to a record about 50 records beyond where I was at (but not EOF).
I have a RequestLive, AutoCommit, tsCommitted setup; this whole thing is
Local.
I assume that I need to use UPDATE SQL to actually change the record,
not post, but I'm really curious why this doesn't work and why the
record seems to jump when POST is encountered in a debug session?
Thanks for your help and patience with my newbie question,
Chuck Belanger
Hoping someone can help me to understand something (I'm still very new
to IBO, IB and Delphi):
Using IBO: TIBOQuery component with Woll2Woll components, but because
there was no Tww checkbox, I used a LED and its ONCLICK event to change
and show the state of a Boolean field. I'm using this in conjunction
with their dbTreeView and everything works fine, except when I want to
update the field, initially I tried to edit, getfieldbyname, post which
did not update the underlying datasource, and caused the display to
point to a record about 50 records beyond where I was at (but not EOF).
I have a RequestLive, AutoCommit, tsCommitted setup; this whole thing is
Local.
I assume that I need to use UPDATE SQL to actually change the record,
not post, but I'm really curious why this doesn't work and why the
record seems to jump when POST is encountered in a debug session?
Thanks for your help and patience with my newbie question,
Chuck Belanger