Re: [sqlite] Looking for SQLite app builder

2018-08-17 Thread R Smith
On 2018/08/17 8:11 PM, Bob Sisson wrote: I am looking for a cross platform app builder that will use SQLite to build an inspection checklist that will build a "summary page" that takes selected check boxes, radio buttons and pull downs and looks up their expanded values and fills in a summary

Re: [sqlite] Looking for SQLite app builder

2018-08-17 Thread Simon Slavin
On 17 Aug 2018, at 7:11pm, Bob Sisson wrote: > but acrobat couldn't deal with over 1,000 fields... You would not want a table with over 1,000 fields. That is an extremely unusual way to use a SQL database. However, I do not thing you want to use SQLite directly, and do all the low level

Re: [sqlite] Looking for SQLite app builder

2018-08-17 Thread Jens Alfke
> On Aug 17, 2018, at 11:11 AM, Bob Sisson wrote: > > I am looking for a cross platform app builder that will use SQLite to build > an inspection checklist that will build a "summary page" that takes selected > check boxes, radio buttons and pull downs and looks up their expanded values >

Re: [sqlite] Looking for SQLite app builder

2018-08-17 Thread Rich Shepard
On Fri, 17 Aug 2018, Bob Sisson wrote: I am looking for a cross platform app builder that will use SQLite to build an inspection checklist that will build a "summary page" that takes selected check boxes, radio buttons and pull downs and looks up their expanded values and fills in a summary

[sqlite] Looking for SQLite app builder

2018-08-17 Thread Bob Sisson
I am looking for a cross platform app builder that will use SQLite to build an inspection checklist that will build a "summary page" that takes selected check boxes, radio buttons and pull downs and looks up their expanded values and fills in a summary page to be printed. We have tried several

Re: [sqlite] Invalid Blob Length Error Message

2018-08-17 Thread Clemens Ladisch
Casey Rodarmor wrote:> Hi all, > unrecognized token: "x'01234' > > I know now that the problem was that the blob's length was not a > multiple of two. However, the error message didn't give me an > indication of that. Would it be possible to make the error message > more explicit, to help users

Re: [sqlite] Invalid Blob Length Error Message

2018-08-17 Thread J Decker
On Fri, Aug 17, 2018 at 5:14 AM Tim Streater wrote: > On 17 Aug 2018, at 01:24, Casey Rodarmor wrote: > > > I wrote an erroneous update statement: > > > > ``` > > UPDATE foo SET bar = x'01234'; > > ``` > > > > The error message was: > > > > ``` > > unrecognized token: "x'01234' > > ``` > > > >

Re: [sqlite] Invalid Blob Length Error Message

2018-08-17 Thread Tim Streater
On 17 Aug 2018, at 01:24, Casey Rodarmor wrote: > I wrote an erroneous update statement: > > ``` > UPDATE foo SET bar = x'01234'; > ``` > > The error message was: > > ``` > unrecognized token: "x'01234' > ``` > > I know now that the problem was that the blob's length was not a > multiple of two.

[sqlite] Invalid Blob Length Error Message

2018-08-17 Thread Casey Rodarmor
Hi all, I wrote an erroneous update statement: ``` UPDATE foo SET bar = x'01234'; ``` The error message was: ``` unrecognized token: "x'01234' ``` I know now that the problem was that the blob's length was not a multiple of two. However, the error message didn't give me an indication of that.