On Mon, 18 Nov 2013, mulcamd wrote:
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.
I cannot create the table with the SQL you posted.I get a Error: duplicate column name: from sqlite.
Meanwhile you can try the following: First of all, make sure you are using an ansistring variable instead of a shortstring variable. If that is OK, and you still get only 255, try using a cast expression: Select id_local, cast (xmp as text) from Adobe_AdditionalMetadata or Select id_local, cast (xmp as BLOB) from Adobe_AdditionalMetadata Michael.
-- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
