Hi, thanks, it works!
Van: K. P. [mailto:platyster...@hotmail.com]
Verzonden: dinsdag 26 november 2013 01:18
Aan: lazarus@lists.lazarus.freepascal.org
Onderwerp: Re: [Lazarus] SQLite Vacuum & Error Cannot rollback - no
transaction is active
As the error message indicates, do:
SQLite3C
At the end of some database maintenance where I drop several tables I want
to Vacuum the SQLite database.
I use the code below and this works fine, however when I close the program I
get the error:
"Project project1 raised exception class 'EDatabaseError' with message:
Cannot rollback - no tr
Message-ID:
Hi,
The solution was:
SQLQuery1.SQL.Text:='Select id_local, cast(xmp as blob) as xmp from
Adobe_AdditionalMetadata';
Thank you Michael Van Canneyt for the tip!
-Oorspronkelijk bericht-
Van: mulcamd [mailto:mulc...@hotmail.com]
Verzonden: dinsdag 19 november
Date: Tue, 19 Nov 2013 09:27:23 +0100 (CET)
From: Michael Van Canneyt
Subject: Re: [Lazarus] Help reading SQLite field with more than 255
chars
To: Lazarus mailing list
Message-ID:
Content-Type: text/plain; charset="iso-8859-7"; Format="flowed"
On Mon, 18 Nov
I'm reading the SQLite database of Adobe Lightroom (SQLite).
I want to process the AdditionalMetadata table, see below, the XMP field,
which may be 3000 chars long.
When retrieving the contents of this field I only get 255.
Question:
What should I do to get the full content of this field.
