{"id":53,"date":"2007-05-08T15:44:43","date_gmt":"2007-05-08T13:44:43","guid":{"rendered":" http:\/\/www.nsonic.de\/blog\/2007\/05\/database-d5d6-error-with-db-access\/"},"modified":"2007-05-11T19:38:37","modified_gmt":"2007-05-11T17:38:37","slug":"database-d5d6-error-with-db-access","status":"publish","type":"post","link":"https:\/\/www.nsonic.de\/blog\/2007\/05\/database-d5d6-error-with-db-access\/","title":{"rendered":"Database: D5\/D6 Error with DB-Access"},"content":{"rendered":"

Q:
\n—-
\nI have two query connect to DBDemos.<\/p>\n

Query1.sql
\nselect name
\nfrom country<\/p>\n

Query2.sql (connect to query1)
\nselect *
\nfrom country
\nwhere name = :name<\/p>\n

Query1 connect to a DBGrid and Query2 connect to a group of DBEdit.
\nWhere I scroll Query1 record in DBGrid, Query2 record in DBEdit will
\nnot change. But when I replace DBEdit to DBGrid and also connect to
\nQuery2. It WORKS.<\/p>\n

This error ever occured in Delphi 5 but solve in Delphi 5 Patch 1.<\/p>\n

It is a simple error but a IMPORTANT bug.
\n<\/em><\/p>\n

A:
\n—-
\nChange TFieldDataLink’s UpdateField to<\/p>\n

[code lang=”delphi”]procedure TFieldDataLink.UpdateField;
\nbegin
\n SetField(nil);
\n if Active and (FFieldName <> ”) then
\n begin
\n if Assigned(FControl) then
\n SetField(GetFieldProperty(DataSource.DataSet, FControl, FFieldName)) else
\n SetField(DataSource.DataSet.FieldByName(FFieldName));
\n end
\nend;
\n[\/code]<\/p>\n

and statically link in the changed pas file. As you noticed this bug was in D5
\nshipping, fixed in SP1 but for some reason reverted back in D6 to the buggy
\nversion.<\/p>\n","protected":false},"excerpt":{"rendered":"

Q: —- I have two query connect to DBDemos. Query1.sql select name from country Query2.sql (connect to query1) select * from country where…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":""},"categories":[11],"tags":[75,80,83],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p71Tml-R","_links":{"self":[{"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/posts\/53"}],"collection":[{"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/comments?post=53"}],"version-history":[{"count":0,"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/posts\/53\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/media?parent=53"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/categories?post=53"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/tags?post=53"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}