Re: [sqlite] Verison 3.19.2 no longer opens my database
Are you on Windows? Can you install a compiler? If so then there's gcc for windows at http://tdm-gcc.tdragon.net/download or what used to be Borland C++, is now Embarcadero and much updated to version 10 at https://www.embarcadero.com/free-tools/ccompiler/start-for-free - you will need to register for this one. Both will compile the Sqlite library source, but the latter compiler needs a couple of changes (which i must post at some point soon!) To compile the Sqlite3 command line utility. I've used both successfully. If, on the other hand you are unable to install a compiler, pretend I never sent this! Cheers, Norm. On 9 June 2017 13:15:45 BST, Martin Lowry wrote: >Hi > >Richard, thanks for the quick reply. Unfortunately compiling the >library myself is not an option since I have no C/C++ compiler >available. Looks like I'll have to live with my workaround. > >Cheers, > >Martin > > >On 09/06/2017 12:40, Richard Hipp wrote: >> On 6/9/17, Martin Lowry wrote: >>> In version 3.11.1 sqlite3_table_column_metadata >>> failed with a non-zero exit code which was easier to deal with. >> If you compile with -DSQLITE_ENABLE_API_ARMOR, then invoking >> sqlite3_table_column_metadata() with a NULL zTableName value will >> return SQLITE_MISUSE - which is non-zero, but which should also be a >> clue that you are doing something wrong. >> >> I will update this documentation to make it clear that the table name >> parameter to sqlite3_table_column_metadata() may not be null. > >= -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] How many AUTOINCREMENT tables are in your schema?
5. 5 tables in my first SQLite database. Cheers, Norm. -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Task management schema
Hi David, This might help ... https://www.google.co.uk/search?q=recurring+calendar+database+design&oq=recurring+calendar+database+design Granted it's just a Google search but the results look promising. Good luck. Cheers, Norm. -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] bug: compare number with empty string get different resut
Duck Typing? Never heard that before. Cheers, Norm. -- Sent from my Android device with K-9 Mail. Please excuse my brevity and any "auto corrections" that are just wrong! ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] bug: compare number with empty string get different resut
Ok, thanks everyone, it's perfectly clear now. Cheers, Norm. -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] The mailing list is deprecated...... [was: Re: [EXTERNAL] No such column error]
It originally came from Dr Richard Hipp. It's official. HTH Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: 27a Lidget Hill Pudsey West Yorkshire United Kingdom LS28 7LG Company Number: 05132767 On 24/03/2020 08:13, Luuk wrote: On 24-3-2020 09:04, Luuk wrote: "The mailing list is deprecated. You need to go to https://sqlite.org/forum/ for the sqlite forum." Can anyone give the source of this? No, i do NOT mean the source of the forum, but the source for "The list is deprecated" ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users