Gentlefolk,
I asked this question a very long time ago and received an answer. Somehow in moving things from system to system the answer has been lost.
In a DBGrid I accumulate data in a cell and then on the <enter> I need to check the input for non numeric data, syntax, etc and convert the input into a standard format, for instance 41523 has to be converted to 4:15.23.
I can do all this by accessing the data in
procedure TFM.DBGrid1KeyUp(Sender: TObject; var Key: Word; Shift: TShiftState);
TStringCellEditor(tDBGrid(Sender).InplaceEditor).EditText
The question is how do I write the contents of EditText to a field in the current record of the underlying SQLQuery?
From long memory it was something in the area of procedure
TFM.SQLQueryHeatBeforeInsert(DataSet: TDataSet)
But all efforts around that part of the code have resulted in the original non parsed input and/or the parsed version in the next record of the SQLQuery.
An help appreciated, Ian.