SQLite Forum

Timeline
Login

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

50 most recent forum posts by user dvdraymond

2022-08-10
18:01 Reply: Finding what PRAGMA options has been set (artifact: 66f8c0e232 user: dvdraymond)
2022-08-09
17:03 Reply: Index Bug (artifact: db4339a3b0 user: dvdraymond)
11:53 Reply: newbie Catch error when inserting duplicate in BEGIN+END block (artifact: 5f3d795daf user: dvdraymond)
11:44 Reply: newbie Catch error when inserting duplicate in BEGIN+END block (artifact: 0ac4d925ea user: dvdraymond)
11:28 Reply: DB Browser (SQLite) - view data out of different db's (artifact: cca9bcfe70 user: dvdraymond)
2022-08-08
12:40 Reply: GROUP BY failing to GROUP (artifact: 033a2157d2 user: dvdraymond)
2022-08-05
17:47 Edit reply: Sublte difference between aggregation and unique index? (artifact: 6b0a25fc14 user: dvdraymond)
17:46 Edit reply: Sublte difference between aggregation and unique index? (artifact: 9515d2d5b6 user: dvdraymond)
17:46 Reply: Sublte difference between aggregation and unique index? (artifact: 10669145fc user: dvdraymond)
17:39 Reply: Sublte difference between aggregation and unique index? (artifact: cf2028c4dd user: dvdraymond)
14:30 Edit reply: Conflict resolution between upsert and triggers (artifact: e44e50a7f7 user: dvdraymond)
14:29 Reply: Conflict resolution between upsert and triggers (artifact: ee60faeca7 user: dvdraymond)
14:22 Reply: Sublte difference between aggregation and unique index? (artifact: c3e63d4b42 user: dvdraymond)
2022-08-03
13:36 Reply: Using one of the field values of a SELECT (artifact: 7862b8b64a user: dvdraymond)
2022-08-02
18:56 Reply: Index Bug (artifact: 13748e569f user: dvdraymond)
2022-08-01
18:20 Edit reply: UPSERT ON CONFLICT enhancement (artifact: 2a8c23811f user: dvdraymond)
18:19 Reply: UPSERT ON CONFLICT enhancement (artifact: 716c27eb35 user: dvdraymond)
2022-07-22
14:42 Reply: max() function broken (artifact: 67a1c5fa53 user: dvdraymond)
2022-07-20
13:04 Reply: Change access to readonly (artifact: f8b4257fc7 user: dvdraymond)
12:20 Reply: How do I display empty fields in a column with "no description"? (artifact: 73fdcd1ae3 user: dvdraymond)
2022-07-18
12:21 Reply: max() function broken (artifact: f76a5af14c user: dvdraymond)
2022-07-15
17:51 Reply: possible to use DISTINCT with wildcard? (artifact: 4628b7008e user: dvdraymond)
2022-07-14
14:07 Reply: Feature Request: Support for `BIGINT PRIMARY KEY AUTOINCREMENT`? (artifact: ce96433039 user: dvdraymond)
2022-06-29
15:33 Reply: Prevent prefixes in column (artifact: 3286ea8dc4 user: dvdraymond)
12:50 Reply: Prevent prefixes in column (artifact: 69e8a43e73 user: dvdraymond)
2022-06-28
19:18 Reply: Prevent prefixes in column (artifact: 282cf118c2 user: dvdraymond)
15:18 Reply: Prevent prefixes in column (artifact: 3f5f81de3f user: dvdraymond)
14:26 Reply: Unclear why join is so much slower than separate queries (artifact: e23f9c6057 user: dvdraymond)
2022-06-17
18:50 Reply: Conditionnal Update a field from another field (artifact: ad029cf0ab user: dvdraymond)
2022-06-16
15:54 Reply: BUG: DELETE / DROP TABLE fails with self referencing FK data (artifact: ac3ed3f2af user: dvdraymond)
2022-06-10
16:48 Reply: Aggregate function by multiple columns (artifact: 3e5958039b user: dvdraymond)
16:37 Reply: Aggregate function by multiple columns (artifact: e73a4bf49d user: dvdraymond)
16:04 Reply: Match All IN (value1, value2, etc) (artifact: 55b030c686 user: dvdraymond)
2022-05-16
13:10 Reply: Inserting into two tables in one statement, one of which requires a foreign key reference to the other? (artifact: 024927d57a user: dvdraymond)
2022-05-03
18:53 Reply: Two queries work separately, but fail when combined (artifact: 0ca736812e user: dvdraymond)
2022-04-26
17:54 Reply: Max() over datetime field (artifact: aadaac5040 user: dvdraymond)
17:24 Reply: Max() over datetime field (artifact: 8665aba164 user: dvdraymond)
2022-04-21
13:35 Reply: Parser bug in INSERT .. SELECT .. ON CONFLICT clause (artifact: a116917be9 user: dvdraymond)
13:23 Reply: Parser bug in INSERT .. SELECT .. ON CONFLICT clause (artifact: 16fcd671e2 user: dvdraymond)
2022-04-06
20:09 Reply: DOT commands - Is there a way to concatenate multiple commands? (artifact: 13655a9fc3 user: dvdraymond)
2022-04-05
15:14 Reply: Many-To-Many problem (artifact: 5018ddab1a user: dvdraymond)
2022-03-31
18:59 Reply: Selected RowId Not Returned after .input (artifact: d2d8484ec7 user: dvdraymond)
2022-03-21
19:58 Reply: Possible to see how many opcodes were executed for a query? (artifact: 330c8532d8 user: dvdraymond)
15:59 Reply: Unexpected result from query with window function (artifact: eac169ea1d user: dvdraymond)
2022-03-07
20:06 Reply: Search for a range of characters (artifact: 6b4269ac87 user: dvdraymond)
19:32 Reply: Search for a range of characters (artifact: 4bc798757c user: dvdraymond)
2022-02-25
13:33 Reply: Enhancement Idea: Rollback And Release Savepoint (artifact: 4b489d87e4 user: dvdraymond)
2022-02-09
19:57 Reply: Journal recreating for every execution (artifact: a136e9b30e user: dvdraymond)
2022-01-31
17:09 Reply: Query against view of two joined tables not using index; bug or missed optimization? (artifact: 189c3e0790 user: dvdraymond)
17:04 Reply: Query against view of two joined tables not using index; bug or missed optimization? (artifact: f8024404ea user: dvdraymond)