[fpc-pascal] FreePascal and MySQL ?

Snorkl e tony.caduto at gmail.com
Mon Nov 20 17:40:22 CET 2017


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


On Nov 20, 2017 10:02 AM, "Terry A. Haimann" <terry at haimann.us> wrote:

> 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.
>
> _______________________________________________
> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freepascal.org/pipermail/fpc-pascal/attachments/20171120/e9ef0308/attachment.html>


More information about the fpc-pascal mailing list