SQLite Forum

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 most recent forum posts by user TripeHound

2022-05-02
13:51 Reply: Possible Wrong Results of the Group By Clause (artifact: 425168181b user: TripeHound)
2022-04-14
16:40 Reply: Foreign Key reference behavior with multiple databases attached (BUG??) (artifact: 6c58ebdd63 user: TripeHound)
2022-03-20
08:12 Reply: Unable to update table data using ODBC (artifact: 4f16fe90de user: TripeHound)
2022-03-06
09:04 Reply: CASE TYPEOF(field) WHEN 'text' THEN .... doesn't seem to work (artifact: 8a48f0d13a user: TripeHound)
2022-02-20
22:43 Reply: why is an empty field evaluate to greater than an integer? (artifact: 166ce62cd1 user: TripeHound)
2022-02-10
23:07 Reply: while updating sqlite jdbc 3.34.0 to sqlite-jdbc-3.36.0.3 its showing error org.sqlite.SQLiteException: SQLITE_CORRUPT (artifact: be615b8a0b user: TripeHound)
2022-01-24
13:08 Reply: binding by reference instead of value (artifact: c77c5b69a6 user: TripeHound)
2022-01-18
22:46 Reply: Help me understand the path syntax used by json_extract() (artifact: 62c35df322 user: TripeHound)
2022-01-10
07:44 Reply: Using SQLITE_OMIT_xxx in SQLite 3.36 (artifact: eea74051eb user: TripeHound)
2022-01-01
08:52 Reply: My code's ATTACH will not create a new db but sqlite3's shell will? (artifact: b8850ce467 user: TripeHound)
2021-12-29
00:28 Reply: Serious error emptied my complete database! (artifact: 052af783af user: TripeHound)
2021-12-15
15:33 Reply: Error: stepping, unable to open database file (14) (artifact: ecfccced59 user: TripeHound)
2021-08-08
20:38 Reply: Getting a date range using "like" (artifact: 9a3c8bba44 user: TripeHound)
15:30 Reply: Getting a date range using "like" (artifact: e41b95c26e user: TripeHound)
2021-07-22
22:06 Edit reply: Compile error when symbols SQLITE_OMIT_SHARED_CACHE and SQLITE_USER_AUTHENTICATION=1 are both defined (artifact: 091bb655e4 user: TripeHound)
22:02 Reply: Compile error when symbols SQLITE_OMIT_SHARED_CACHE and SQLITE_USER_AUTHENTICATION=1 are both defined (artifact: 4389d16629 user: TripeHound)
2021-07-13
09:06 Reply: "=" character not mentioned in expr syntax definition (artifact: 657dd8b19d user: TripeHound)
2021-07-07
13:42 Reply: Shortcut to change a non changing update or upsert in a noop (artifact: c44fc8a646 user: TripeHound)
2021-07-02
06:09 Reply: Incorrect Result From SQLite Query (artifact: f467ecf01e user: TripeHound)
2021-05-13
09:12 Reply: How to convert am/pm time to 24hrs time format (artifact: b4ce3bfcec user: TripeHound)
2021-05-05
08:53 Reply: Why do I have a `SQLITE_AUTOINDEX` index for my primary key? Is the table itself not an index on the PK? (artifact: 56aa9f593f user: TripeHound)
2021-04-10
14:11 Reply: useless constant term lead to incorrect output (artifact: 173c42f489 user: TripeHound)
2021-03-30
19:41 Reply: Atomically initialize database (artifact: 9b1f89b3fd user: TripeHound)
2021-03-29
09:20 Reply: Query Contraint with an if clause? (artifact: 6b3616c189 user: TripeHound)
2021-03-27
14:49 Reply: Novice question about running UTF-8 on CLI from file. (artifact: ad6d5f92c7 user: TripeHound)
2021-03-25
22:36 Edit reply: json_tree documentation improvement: change type "string" to "text" (artifact: e56a7597e7 user: TripeHound)
22:35 Reply: json_tree documentation improvement: change type "string" to "text" (artifact: 3e86be3c6d user: TripeHound)
2021-03-23
11:07 Reply: Strange CLI .exit issue (artifact: f1ecabfa8a user: TripeHound)
2021-03-19
14:13 Edit reply: error changing data - attempt to write a readonly database (artifact: 4e47e93711 user: TripeHound)
14:11 Reply: error changing data - attempt to write a readonly database (artifact: 02e8989aea user: TripeHound)
2021-03-17
23:48 Reply: Math functions for arguments outside the domain should raise exception according to SQL Standard (artifact: 07c3936a79 user: TripeHound)
2021-03-12
16:48 Reply: Unable to load dll 'SQLite.interop.dll' after installing my app. The dll is present in the application folder (artifact: c8237a0d39 user: TripeHound)
2021-02-28
16:38 Post: Ultra-minor typo in documentation (artifact: af2c9cf0f1 user: TripeHound)
15:07 Reply: SQLite-related problem with the Signal app (artifact: 5624f24c61 user: TripeHound)
2021-02-21
16:35 Reply: Update database item (artifact: af41e956e5 user: TripeHound)
2021-02-01
21:02 Reply: Approximate COUNT(*) using sqlite_stat4 (artifact: 267eb3dcba user: TripeHound)
2021-01-28
10:50 Reply: Compiling amalgamation with Visual Studio 2019 (artifact: 720df5a754 user: TripeHound)
2021-01-16
07:29 Reply: "Hello, world" CGI with althttpd (artifact: 151a543486 user: TripeHound)
2021-01-14
14:06 Reply: Using android AAR with modified sqlite_open_v2() - attach gives problems (artifact: 0f29669bf8 user: TripeHound)
2021-01-11
10:17 Reply: Possible Bug (artifact: ec313fa2cd user: TripeHound)
2021-01-08
09:56 Reply: Additional Delimiter Support for the CSV Virtual Table Module (artifact: e2cea10f26 user: TripeHound)
2021-01-05
09:51 Reply: Make a time-range query faster when "GROUP BY day" (artifact: ef0d0d63b9 user: TripeHound)
2020-12-03
09:54 Reply: Request: Conform to XDG Base Directory Specification for sqliterc configuration file (artifact: 4c5c832cf5 user: TripeHound)
2020-11-30
15:58 Edit reply: FTS5 Handling of multi-token phrases (artifact: 17a2e0e7f3 user: TripeHound)
15:57 Reply: FTS5 Handling of multi-token phrases (artifact: b14faac1df user: TripeHound)
2020-11-24
21:22 Reply: SQLite ODBC (artifact: 3097d06505 user: TripeHound)
2020-11-17
09:37 Reply: Serious Sqlite command line Problems after Windows 10 update (artifact: 3fd467df57 user: TripeHound)
2020-10-31
22:15 Edit reply: SQLite: -tabs option is missing (artifact: 36d4c152d8 user: TripeHound)
18:38 Reply: SQLite: -tabs option is missing (artifact: dea24851de user: TripeHound)
2020-09-29
09:17 Reply: DISTINCT does not work in CTE (artifact: 25520cb153 user: TripeHound)