Hello,

This is probably a dumb question. But I have data in a tstringlist that I want to upload into a MediumText MySQL column. It looks to me as if you do something like:

	Stream := TMemoryStream.Create;
	MySL.SaveToStream(Stream);
	Blobfield(BcfQuery.FieldByName('JobMemo')).
		LoadFromStream(Stream);

But what I don't understand is how I indicate what row to add the MediumText field to. Is there some way to combine this with an insert or update statement. I have done a lot in the past with MySQL and FreePascal, but I have mostly or entirely worked with standard columnar data, i.e. (Strings, floats and integers).

Thanks in advance,

Terry H.

You don't need to use a stream just do
Dataset.fieldbyname('somecolumn').asstring:=mystringlist.text

Edits are always on the current row in the dataset.

Michael.