Work doing economic, statistical analysis and data retrieval for a provincial government department. Mostly only write Clarion programs for my own use (project management, data viewers, etc.) Occasionally write small programs for other people in the Department will use, especially when it will save me down the road from having to make sense of multiple mangled spreadsheets.

Working on a way to improve the dictionary end of Clarion. Normally start a project by defining tables in Oracle, then in the course of working on the application have to go through multiple iterations of adding or changing a field on either the Clarion end or the Oracle end, and having to duplicate the change on the other side. Have had too many bad experiences witht he synchronizer to trust it…

So, have set up tables in Oracle that hold all of the info (that I regularly use) from the Clarion dictionary. Have a procedure to import from the application’s Oracle schema, and a view to export the dictionary info to a Clarion .dctx and make that into a dct using clarioncl. Overall aim is to have a replacement dictionary editor that will manage both sides at once. Should save me a lot of time.