Ok so we all saw this topic coming, after my previous one on saving checkbox state....
Really baffled by this one because I've used this exact code before in another test project (only changing the names of the fields and objects), and it worked perfectly. UserFileLoad is a TSQL query. Just as a proof of concept I'm getting the data from the query and putting it in a field, tempdisplay2, but in the real world all the data will be true/false so I assume I can read it as a StrToBool and then set each checkbox state accordingly.
UserFileConnection.Open;
UserFileTransaction.Active:= True;
UserFileLoad.SQL.Text:=('SELECT * FROM IssueSpecific WHERE _rowid_=:RowParam');
UserFileLoad.Params.ParamByName('RowParam').Value := TempRecordNum.text;
UserFileLoad.ExecSQL;
UserFileTransaction.Commit;
tempdisplay2.Text := UserFileLoad.Fields[1].AsString;
It compiles, then when I click the appropriate button I get:
Project raised exception class 'EListError' with message:
List index (1) out of bounds