Search found 63 matches: sqlite blob

Searched query: sqlite blob

by n.allan
Fri May 15, 2020 12:10 pm
Forum: Databases
Topic: SQLite Database BLOB is identified as STRING
Replies: 3
Views: 436

Re: SQLite Database BLOB is identified as STRING

... Your solution has solved the problem. The data type is now showing as BLOB and the full chunk of data is now in the tImage variable. my final handler ... db as "binary" and this has corrected the issue put revOpenDatabase("sqlite","countries-raster.mbtiles", "binary") into tID -- open the database ...
by LCMark
Fri May 15, 2020 11:48 am
Forum: Databases
Topic: SQLite Database BLOB is identified as STRING
Replies: 3
Views: 436

Re: SQLite Database BLOB is identified as STRING

@n.allan: The sqlite driver originated with SQLite2 which did not support binary data... This meant that binary data had to be explicitly encoded as text and then decoded (when using the *b). If your database is coming from another ...
by bangkok
Fri May 15, 2020 11:43 am
Forum: Databases
Topic: SQLite Database BLOB is identified as STRING
Replies: 3
Views: 436

Re: SQLite Database BLOB is identified as STRING

... to aid in debugging set the defaultFolder to specialFolderPath("resources") -- place the database file beside the stack put revOpenDatabase("sqlite","countries-raster.mbtiles") into tID -- open the database if tID is not a number then -- In my test tID is a valid integer meaning the connection ...
by n.allan
Fri May 15, 2020 10:01 am
Forum: Databases
Topic: SQLite Database BLOB is identified as STRING
Replies: 3
Views: 436

SQLite Database BLOB is identified as STRING

I am having trouble reading BLOB data from an SQLite database file. In my sqlite database there is a table called tiles. The columns in it are zoom_level ...
by lohill
Sun May 03, 2020 2:19 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Encryption and SQLite
Replies: 7
Views: 879

Encryption and SQLite

... KEY AUTOINCREMENT NOT NULL, cipher char(64), rootKey char(64), simplePW blob ); CREATE TABLE account ( aKey integer PRIMARY KEY AUTOINCREMENT NOT ... put the cDatabaseStructure of this stack into tSQL put revOpenDatabase("sqlite", tPath,"binary") into tDatabaseID revExecuteSQL tDatabaseID, tSQL ...
by bogs
Fri Feb 21, 2020 11:45 am
Forum: Windows
Topic: Save main stack SQLite
Replies: 7
Views: 795

Re: Save main stack SQLite

... sure I understand the question fully, so pardon my ignorance. While a blob in sqlite is generally there for storage of binary data, sqlite itself is a single user accessed ...
by SkinnyKenny
Fri Feb 21, 2020 10:38 am
Forum: Windows
Topic: Save main stack SQLite
Replies: 7
Views: 795

Save main stack SQLite

... if it was possible to save the current state of a main stack into a "Blob" container using SQLite. What I am trying to accomplish is keeping the data up to date in my main stack when ...
by paulalsmith1000
Thu Aug 01, 2019 10:28 pm
Forum: Data Grid Helper
Topic: datagrid form save / update sqlite
Replies: 10
Views: 2214

datagrid form save / update sqlite

Dear Anyone Thanks very much for all your help on my last post about blob images, after many hours its now working fine (I am however starting ... survey (these pictures are taken earlier in the app and saved in the sqlite db, then used to populate the form). This bit I can do -the field "species ...
by sphere
Sat Jul 06, 2019 10:26 am
Forum: Data Grid Helper
Topic: blob images in datagrid
Replies: 7
Views: 2157

Re: blob images in datagrid

... you know via the lesson how to add fields and images to a row then: i use a handler to populate the grid, this is an simple example to use a local sqlite db. Assuming you have a sqlite db with data in it. I don't use that anymore for filling my DG, i now use a remote DB and use php as middleware ...
by paulalsmith1000
Fri Jul 05, 2019 8:16 am
Forum: Data Grid Helper
Topic: blob images in datagrid
Replies: 7
Views: 2157

blob images in datagrid

... to quite answer the question / solve the problem:- basically I have an sqlite db with some records and an image (blob) associated with each record (the fields are survey_id, gps_location, species_name, species_image, ...
by bogs
Mon May 20, 2019 4:50 pm
Forum: Databases
Topic: Looking for example of linked image sqlite DB
Replies: 4
Views: 1768

Re: Looking for example of linked image sqlite DB

If I have 300 to 500 electronic parts in an sqlite LiveCode desktop application, would putting 1 to 5 small images (perhaps ... I understand that storing the images would be as binary files. Well, as a blob, but not necessarily as binary. I believe the recommended way would be to textencode/decode ...
by TerryL
Fri Apr 19, 2019 7:05 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: SQLite Foreign Key Constraint
Replies: 6
Views: 1243

Re: SQLite Foreign Key Constraint

... creating tables with foreign keys activated. I found buried in the SQLite documentation, https://sqlite.org/foreignkeys.html "It is not possible ... ); COMMIT; PRAGMA foreign_keys = ON; @ Bogs: I'm still against BLOB input with too many difficulties to overcome. It seems easier to me ...
by TerryL
Mon Apr 01, 2019 7:10 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: SQLite Foreign Key Constraint
Replies: 6
Views: 1243

Re: SQLite Foreign Key Constraint

Hi Bogs. Thank you for the BLOB links. Yes I will look into it. For now I've concluded its too difficult for me to implement, so I'm posting the stack. Stack "DB SQLite" for personal use or create an SQLite database for your client's use as a front-end. ...
by bogs
Thu Mar 28, 2019 10:24 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: SQLite Foreign Key Constraint
Replies: 6
Views: 1243

Re: SQLite Foreign Key Constraint

If anyone has a solution for inserting and selecting BLOB I'm interested! Well, there are lots of solutions. Did you read Max's Wiki article on it? Other than that, right here in the forums there are plenty of posts about the topic . 99% recommend ...
by TerryL
Thu Mar 28, 2019 9:37 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: SQLite Foreign Key Constraint
Replies: 6
Views: 1243

Re: SQLite Foreign Key Constraint

Hi Dunbarx. This project was a front-end for any SQLite db. It would have been much easier hard coding for one SQLite db. I agree ... the stack. I'm still writing the Help section, and I'm stuck on the binary BLOB field type, for which LC requires special consideration. If anyone has a solution ...

Go to advanced search