I have cut this down to a simple example.
The access file has a table called rooms which contains a description field of type memo
I want to load this into a dbmemo (delphi 7) I run this by a button onclick event
procedure TForm1.Button1Click(Sender: TObject); begin adoquery1.close; adoquery1.SQL.Clear; ADOQuery1.SQL.Add('Select description from Rooms'); adoquery1.Active := true; adoquery1.Open; end;
problem is that it puts nothing in the dbmemo.
I can get it to work with a dbgrid, but I guess thats not the point.
Further, I am not sure how to debug this kind of code to see what is happening, hints to that effect would be appreciated also.