Paradox Community

Items in pnews.paradox-programming

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?
>>
>>>
>>>
>>>
>>>
>>>
> 


Copyright © 2004 thedbcommunity.com