SQLite Forum

Timeline
Login

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

50 most recent forum posts by user dvdraymond

2024-03-07
13:18 Reply: Insert ON CONFLICT, add a new row (artifact: 16d894ca86 user: dvdraymond)
2024-02-15
16:09 Reply: Foreign key mismatch issues (artifact: c220e73149 user: dvdraymond)
2024-01-27
13:35 Reply: problem implementing multi-statement transactions (artifact: 07b73ef990 user: dvdraymond)
2024-01-16
13:57 Reply: Query sum or different if in ather field ther is 1 or 2 (artifact: bf11aa12db user: dvdraymond)
2024-01-11
13:40 Reply: SQL error: near "CASE": syntax error (artifact: 10ab0c2284 user: dvdraymond)
2023-11-29
13:39 Post: Email change (artifact: b275c4bb02 user: dvdraymond)
2023-11-27
15:59 Reply: cloning a table (artifact: 80c6eb8c65 user: dvdraymond)
2023-11-09
16:16 Reply: unexpected results when adding keyword ”where“ (artifact: cf3966c999 user: dvdraymond)
2023-11-08
15:19 Reply: Execute trigger once per statement (artifact: 6a51d50493 user: dvdraymond)
12:43 Reply: How to modify unique autoindex to address nullable field problem (artifact: 906bf7a87a user: dvdraymond)
2023-11-07
17:20 Reply: UPDATE FROM with aggregate functions (artifact: aa02cfc98d user: dvdraymond)
2023-11-06
13:24 Reply: Minor documentation issue (artifact: e5029c1b9c user: dvdraymond)
2023-11-03
18:31 Reply: Performant 'append-only' batched atomic writes? (artifact: 6ac5ee9e53 user: dvdraymond)
2023-11-02
12:44 Reply: Dependent query cannot refer aggregate expr in more than 1 nesting level (artifact: c6c10a3d8f user: dvdraymond)
2023-10-30
15:26 Reply: Using DETERMINISTIC UDF in generated column results in "unsafe use of fct" error. (artifact: ded2ce2855 user: dvdraymond)
13:07 Edit reply: rtree returns different results for BETWEEN vs > AND < (artifact: bdb4780bec user: dvdraymond)
13:01 Reply: rtree returns different results for BETWEEN vs > AND < (artifact: 68a0fa1b82 user: dvdraymond)
2023-10-27
17:24 Edit reply: Discrepancy in behaviour (possible bug?) (artifact: 62deb92b85 user: dvdraymond)
17:15 Reply: Discrepancy in behaviour (possible bug?) (artifact: 653dba5da3 user: dvdraymond)
16:31 Reply: Discrepancy in behaviour (possible bug?) (artifact: 1d320d1471 user: dvdraymond)
2023-10-26
13:31 Reply: Select up to last entered date instead of 'now' (artifact: 2357ca0108 user: dvdraymond)
2023-10-25
19:10 Reply: Foreign key constraint ignored on inserts (FK enabled) (artifact: 3c02b0ce4c user: dvdraymond)
17:09 Reply: Foreign key constraint ignored on inserts (FK enabled) (artifact: 9852560662 user: dvdraymond)
2023-10-24
20:19 Reply: SQLite version 3.44.0 now in beta (artifact: 84153c03ce user: dvdraymond)
14:14 Reply: SQLite version 3.44.0 now in beta (artifact: 5fd59e0511 user: dvdraymond)
2023-10-19
13:38 Reply: Can the views pro week be done with a weeknumber (artifact: 026340c725 user: dvdraymond)
13:01 Reply: Can the views pro week be done with a weeknumber (artifact: dd15fc97aa user: dvdraymond)
2023-10-17
12:35 Reply: Storage of internal B-tree (artifact: c3d9364f08 user: dvdraymond)
2023-10-16
13:06 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? (artifact: 2d29a28444 user: dvdraymond)
2023-10-13
19:16 Reply: UNIQUE column allowing only a single NULL value (artifact: c0b791279e user: dvdraymond)
2023-10-11
19:15 Reply: enabling foreign key support (artifact: b319a054d4 user: dvdraymond)
2023-10-10
19:45 Reply: (Deleted) (artifact: 80a9c616d6 user: dvdraymond)
19:25 Reply: (Deleted) (artifact: 6bb5e311cb user: dvdraymond)
14:29 Reply: Foreign Key Problem (artifact: a71f738d21 user: dvdraymond)
2023-10-02
12:40 Reply: Unexpected result in Handling of NULL Values (artifact: 188f6a5cc0 user: dvdraymond)
2023-09-21
14:22 Reply: SQLITE_CREATE_INDEX and SQLITE_CREATE_TABLE authorizer operations (artifact: 2c47fe05c2 user: dvdraymond)
2023-09-15
19:03 Reply: adding a primary key to an already existing table (artifact: eedc0b6b71 user: dvdraymond)
2023-09-14
14:02 Reply: How can I correctly indicate a link to another table? (artifact: 76d7109574 user: dvdraymond)
12:48 Edit reply: Disabling recursive triggers not working (artifact: 3f1db0cc89 user: dvdraymond)
12:45 Reply: Disabling recursive triggers not working (artifact: a1810be60c user: dvdraymond)
2023-09-13
17:31 Reply: "Runtime error: database disk image is malformed (11)" trying to import large amounts of data (artifact: c2d05414d9 user: dvdraymond)
2023-08-21
11:58 Reply: SQLite 3.42.0 hangs on complex CTE (artifact: 4281d544d7 user: dvdraymond)
2023-08-16
11:43 Reply: Inconsistencies and Anomalies in Query Behavior with Indexed Column (artifact: a08e8b2536 user: dvdraymond)
2023-08-15
12:03 Reply: An User error not detected (syntax check)? (artifact: edb7c12d48 user: dvdraymond)
2023-08-10
18:46 Reply: Numeric literals - underscore separator (artifact: a08e43c0fb user: dvdraymond)
16:48 Reply: BUG: sqlite3 command with option readonly don't cleanup WAL and SHM files (artifact: 85cbc242b1 user: dvdraymond)
2023-08-07
16:49 Reply: Some rows not found using index on integer PK (artifact: ba3eda0154 user: dvdraymond)
2023-08-02
12:42 Reply: Foreign Key Constraint - possible to improve message? (artifact: d3cf45d5de user: dvdraymond)
11:21 Reply: Foreign Key Constraint - possible to improve message? (artifact: 2df902ddfd user: dvdraymond)
2023-07-28
11:20 Reply: PRAGMA integrity_check returns 'TEXT VALUE IN Table.Column' (artifact: abd824189c user: dvdraymond)