Duncan Dewhurst comments

Results 6 comments of


                                            Duncan Dewhurst

%sql fails when query contains a Negative number

Another workaround is to remove the space before the '-': `%sql SELECT DATEADD(month,-2, SYSDATE)`

Variable not being substituted in cell magic with $ or {}

Looks like the same issue I reported in https://github.com/catherinedevlin/ipython-sql/issues/177

Develop schema, publication patterns and documentation around natural person identifiers

From https://github.com/open-contracting/standard/issues/801: Another TYPE is needed for residence card numbers. I suggested RESCARD. Also noting that the BODS schema recommends the use of 3 digit ISO country codes for the...

Typographic updates

Happy to advise on what would be involved in adopting the version management approach documented in OS4D. Is the approach currently used in IATI documented anywhere?

Typographic updates

> The versioning guidance in OS4D seems to presuppose that only one upgrade proposal is in play at once. To clarify, the `-dev` branches are for staging releases, and feature...

Using the Add Record tool to add child features results in missing identifiers

Here are a couple of screen recordings to demonstrate the different behaviours of the Add Record and Add Feature tools, and the problems with the Add Record form. When adding...