Re: [MSEide-MSEgui-talk] Graphic field in SQLite

2011-11-18 Thread IvankoB for-mse
Readme the README's SQLITE3 related : since SQLITE3 doesn't have strict data typing, we MUST always 1) follow the data type mappings 2) use the original sqlite3 utility (pure up-to-date SQLITE3 API) for creating/initial_populating databases. 2011/11/18, Christian Nobel chr.no...@gmail.com:

Re: [MSEide-MSEgui-talk] Graphic field in SQLite

2011-11-18 Thread Martin Schreiber
On Friday 18 November 2011 14.31:31 Christian Nobel wrote: I prefer using Zeos as it makes it easy/elegant changing from one type of database like SQLite to MySQL without to much changes to the program. Ah, the graphicfield problems are with ZEOS? Can you try with tmsesqlquery and

Re: [MSEide-MSEgui-talk] Graphic field in SQLite

2011-11-18 Thread Christian Nobel
Den 18-11-2011 14:53, IvankoB for-mse skrev: In praxis how, meaning by loading to and from a memorystream there is not much I can change?? Declare BLOB field load it with 1) HEX-escaped SQL via CLI or 2) MSE* save-to stream facilities. It works ok, if I use the FreePascal

Re: [MSEide-MSEgui-talk] Graphic field in SQLite

2011-11-18 Thread Martin Schreiber
On Friday 18 November 2011 15.11:12 Christian Nobel wrote: But if opening (or rather trying to) the database with any of the SQLite man's, they now actually crashes, as they cannot read the BLOB correctly. This makes me a bit concerned, as who have actually done it correctly - FreePascal or