Subject: | Re: ExecuteSQL(adb,aSQL,TC) has 32k limit
| Date: | Mon, 4 Sep 2023 05:27:26 +0200
| From: | =?UTF-8?Q?G=c3=bcnter?= <info@NoSpam-mk-news.com>
| Newsgroups: | pnews.paradox-programming
|
No, because of then 32k Limit,
Solved in the way: Linux is easy able to split files,
so i transfer 32k blocks and merge it together in one memo field.
Kevin
thanks for your engagement
problem solved
Am 03.09.23 um 16:10 schrieb Kevin Zawicki:
> 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?
>>
>>>
>>>
>>>
>>>
>>>
>
|