Problem with RefreshRecord

Problem with RefreshRecord

Postby lsc82 » Wed 13 Apr 2005 08:15

Hi,

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.

Thanks
lsc82
 
Posts: 16
Joined: Tue 28 Dec 2004 14:49
Location: Padova, Italy

Postby Ikar » Thu 14 Apr 2005 08:56

SQL Generator for RefreshRecord doesn't work in such cases. Set SQLRefresh manually.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components