Problem with RefreshRecord

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 16
Joined: Tue 28 Dec 2004 14:49
Location: Padova, Italy

Problem with RefreshRecord

Post by lsc82 » Wed 13 Apr 2005 08:15


I've D5, MyDac 3.50.19, MySQL 4.1.10a

I've a TMyQuery with

"select o.*, "" as img from orders o"

If I call RefreshRecord I get the error

Unknow field "img" in field list.


Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Thu 14 Apr 2005 08:56

SQL Generator for RefreshRecord doesn't work in such cases. Set SQLRefresh manually.

Post Reply