Hey Mark, I'm using very simple examples to run it, so I don't think its my
query, but you are eight I shouldreport this. This would be really great to
have. Esp since almost everything is json these days.
I will report it in the next few days. Thanks,
On Fri, Aug 12, 2022 at 12:57 AM Mark Waddin
On 2022-08-11 16:16, Tom Glod via use-livecode wrote:
I was interested in implementing a relatively new feature where you can
index and query json documents and read the keys directly.
https://dgl.cx/2020/06/sqlite-json-support
I guess, if this is true, is there any documentation about which
f
Hi Sean,
The SQLite db i want to read json fields from is local. I know there are
lots of workarounds.
But in link I provided, the premise was using sqlite function to index and
read a jason document's field.
like so:
sqlite> insert into t values(json('{"d":"42"}'));
sqlite> select * from t WH
How was you accessing the database? Is it locally based?
The ones I access are stored on a web host server with a cPanel. I have my own
php I POST my sql request to and receive JSON back. I then use JSONtoArray or,
recommended, JsonImport encapsulated in a ‘try’ structure to convert the data.
Hi Folks,
I have a question about Livecode's SQLite implementation.
Looking at the official SQLite specs there seem to be json related
functions.
https://www.sqlite.org/json1.html
but none of them seem to work using Livecode's driver.
I was under the impression we had a full implementation
I w
