SQLite Forum

Timeline
Login

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

50 forum posts by user hanche occurring on or before 2021-09-28 16:16:48.

2021-09-28
16:16 Edit reply: User -efined functions in the CLI? (artifact: fd466eeb15 user: hanche)
11:24 Reply: User -efined functions in the CLI? (artifact: 33a5985931 user: hanche)
2021-09-20
08:29 Reply: adding record if it doesn't already exist (artifact: 01d741e928 user: hanche)
2021-09-15
06:53 Reply: DELETE FROM … RETURNING (artifact: c17a97d6f9 user: hanche)
2021-09-14
06:57 Reply: Retrieve a record and delete it (artifact: 0fb36361b0 user: hanche)
2021-09-13
10:02 Reply: Wishing CLI could be usefully embedded (artifact: 1e97be257f user: hanche)
2021-08-24
07:15 Edit reply: When is "IS" used in SQLite? (artifact: 0497641c3e user: hanche)
07:10 Reply: When is "IS" used in SQLite? (artifact: d89fdb0953 user: hanche)
2021-08-13
16:52 Reply: Retrieve list of tables (artifact: 92d423e273 user: hanche)
16:33 Reply: Calculating Trip Duration in Minutes? (artifact: 7f1dd0f637 user: hanche)
07:52 Reply: LEFT AND RIGHT OUTER JOINS problem (artifact: ce5e425872 user: hanche)
2021-08-07
06:07 Reply: SQLite3.exe - How to use arguments AND remain in interactive mode? (artifact: 923f6b12ec user: hanche)
2021-08-06
13:14 Reply: Fail to calculate long expression (artifact: d7cced262d user: hanche)
10:34 Reply: Select and count from 2 tables (artifact: 6cedd672f6 user: hanche)
10:26 Reply: SQLite3.exe - How to use arguments AND remain in interactive mode? (artifact: 7c137e0c44 user: hanche)
2021-08-05
08:57 Reply: CAST type-name is optional (artifact: a39ff88674 user: hanche)
2021-08-03
10:45 Reply: Fail to calculate long expression (artifact: faa15478d0 user: hanche)
2021-07-26
20:41 Edit reply: How do I do a one - many join? (artifact: 9e6bd7be9d user: hanche)
20:40 Reply: How do I do a one - many join? (artifact: 771b3e9b95 user: hanche)
2021-07-22
13:01 Edit reply: How to submit changes (artifact: 41d35ba092 user: hanche)
13:00 Reply: How to submit changes (artifact: f82c368f2c user: hanche)
2021-07-20
21:10 Reply: Calculating duration in ISO8601 timestamp (artifact: d4c8ef3851 user: hanche)
2021-07-15
10:46 Reply: Help with a query (artifact: 06b0fa9016 user: hanche)
2021-07-14
07:17 Reply: My Database is being deleted after each restart of my code. How can I fix it? (artifact: 563589a8b5 user: hanche)
2021-07-08
20:16 Reply: edit() function usage (artifact: 1da2477b5a user: hanche)
2021-07-06
15:27 Reply: row value misuse (artifact: d2bc1bf7ad user: hanche)
13:31 Reply: row value misuse (artifact: 6cb4fbeb3f user: hanche)
2021-06-30
21:13 Edit reply: Duplicated rows (and missing rows) when SELECTing with ORDER BY (artifact: 2345d136e4 user: hanche)
21:09 Reply: Duplicated rows (and missing rows) when SELECTing with ORDER BY (artifact: f6d3273fb1 user: hanche)
2021-05-28
07:52 Reply: Column name includes quotes used in RETURNING expr (artifact: 12b5f41297 user: hanche)
2021-05-27
17:44 Reply: Update table from SQLite3 queries results. (artifact: 3705e447eb user: hanche)
14:21 Reply: Is there a way to optimize this UPDATE command to run faster? (artifact: 4e0c9653b7 user: hanche)
2021-05-16
09:48 Reply: Nearest-match join (artifact: 0766947fad user: hanche)
09:44 Reply: Columns metadata is invalit for RETURNING clause (artifact: 4afd278888 user: hanche)
2021-05-15
17:22 Reply: Using json_extract in create table for generated fields (artifact: 688b51826e user: hanche)
2021-05-13
11:47 Reply: How to convert am/pm time to 24hrs time format (artifact: d7f298f383 user: hanche)
2021-05-12
12:20 Reply: How to convert am/pm time to 24hrs time format (artifact: d23be1d9f3 user: hanche)
2021-05-11
19:36 Reply: How to convert am/pm time to 24hrs time format (artifact: 1889232f6c user: hanche)
2021-05-07
08:43 Reply: Get column rank from values in selected row (artifact: 24be65659f user: hanche)
2021-05-06
11:06 Reply: order of INSERT affects the output (artifact: ec95766a77 user: hanche)
10:55 Reply: Is CSV parsing too liberal? (artifact: 094b374050 user: hanche)
2021-05-05
16:09 Reply: SQLite Plus: all the missing SQLite functions (artifact: e947716902 user: hanche)
2021-05-04
18:07 Reply: Is CSV parsing too liberal? (artifact: 44fdf2cb0c user: hanche)
15:02 Reply: Is CSV parsing too liberal? (artifact: fc0abe9802 user: hanche)
13:10 Reply: Is CSV parsing too liberal? (artifact: 2cf97ed870 user: hanche)
11:29 Post: Is CSV parsing too liberal? (artifact: 7df1832eff user: hanche)
2021-05-03
16:14 Reply: insert with returning question (artifact: 96b0dc20ba user: hanche)
2021-05-01
17:45 Reply: Beginner's problem with left join. (artifact: 148aa86490 user: hanche)
08:17 Reply: classic save possibility (artifact: 469e9114b4 user: hanche)
2021-04-25
13:03 Reply: Sending output to a pipe (artifact: 4d3967145e user: hanche)