Mark R Payne

Some further exploring reveals even more wierdness - after disconnecting from the database and reconnecting again, the correct values in the table are correct. Verified on both Ubuntu and Windows....

Thanks for the reply. I'm afraid you may have misunderstood my concerns though - it's the changes at the database level that appear to be the problem, rather than what's...

Thanks for the tip! Setting `debug=TRUE`, here is the SQL that is being run by `rows_update()`: ``` UPDATE "time" SET "doy" = "...y"."doy" FROM "doy" AS "...y" WHERE ("...y"."month" =...

Great to hear that it's not just me then! :-) The creation process is 1. Create database from scratch: `dbConnect(duckdb::duckdb(),"my_database.ddb")` 2. Create blank "time" table and other tables via SQL...

After a bit of hacking around, I was able to get a reprex working without the need for a database i.e. following my general workflow. See below. This reproduces the...

Great idea! I've added the next two questions that beginners have (being a beginner myself!)

Hi Dan, The best place to start with debugging is actually using CDO directly from the command line – once you’ve got the command up and running, then try implementing...