I have to modify a legacy Delphi program to populate a TStringList with data taken from an ODBC source.
The ODBC DSN is called EXCHEQUER and I wish to populate a TStringlist with the idxStockCode field of all the rows read in from the StockCode table. I have set the connectionstring for the ADOConnection1 control but that is as far as I have got. The connection string is : Provider=MSDASQL.1;Persist Security Info=False;Data Source=EXCHEQUER;Mode=Read
I am not a Delphi programmer and so I need step by step help please - that's why its 250 points.