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) | |