So you...
update MARIA table field (Longblob) with this text
getting a JPG file into MARIA SQL table.

Then you want to get that JPG file into a blob in a Paradox table?

Most of the time when I deal with JPGs or PDFs I do not store them in Paradox
table (long term).

Can you extract the JPB from MARIA table and them read the actual JPG into
Paradox blob?




=?UTF-8?Q?G=c3=bcnter?= <info@NoSpam-mk-news.com> wrote:
> > Are you executing it to a return a dataset to a table?
>Yes
>I found no other way to return an JPG to Paraox than
>Linux bash script:
>transfer JPG tp base64 textfile
>update MARIA table field (Longblob) with this text
>Paradox:
>get this field via ExecuteSQL(adb,aSQL,TC)
>;// Execute SQL and return TCursor with WantInMemoryTcursor(Yes)
>
>Am 02.09.23 um 18:34 schrieb Kevin Zawicki:
>> =?UTF-8?Q?G=c3=bcnter?= <info@NoSpam-mk-news.com> wrote:
>>> is there a possibility to get more than 32k as answer from SQL Server?
>>>
>>> it is a Mariadb.longblob field with  76K Chars (base64encoded binary
file)
>> 
>> 
>> 32K as a string?
>> 
>> How are you executing it?
>
>> 
>> 
>> 
>> 
>>