The information in the Apex Guide on the scheduling facility actually doesn't do justice to the cron capability available. For instance you can schedule things to run hourly for given period of the day, but the Apex Guide doesn't provide enough working examples to illustrate uses like that.
Here's a discussion on the practical use of the cron syntax, and you can tell quite a few people still doubt the advanced capability of the cron string.
There must be a very good reason why we complicated our lives with all these technologies ... arguably that is freedom for something. Freedom might be a right but it is never free; so let me demonstrate how I earned it.
Friday, November 23, 2012
Wednesday, November 21, 2012
Can't update Access ... with a linked table
In general you can with most ODBC linked tables. I had no problem with linked SQL Server or Oracle tables. This one only applies to linked CSV files - at least that's the type I've encountered it. I wasn't actually trying to update the CSV file. I was merely using it to join with another linked SQL Server table to identify the rows to update there. I know updating the SQL Server table is not an issue as I'd done it many times. Apparently the limit imposed by the ISAM is indiscriminate enough that it doesn't distinguish which table's columns the query is trying to update - as long as the ISAM support link is used in some fashion, UPDATE won't be supported.
BTW, I assume ISAM mentioned here is the driver used by the Jet engine to link flat files. Amazing how an old term like ISAM - Indexed Sequential Access Method - still survives, which goes back to the early days of mainframe database. Algorithms do have a much longer shelf life than hardware. I bet you can't find any reference to "magnetic core" these days except in computing history articles, which isn't something older than ISAM.
BTW, I assume ISAM mentioned here is the driver used by the Jet engine to link flat files. Amazing how an old term like ISAM - Indexed Sequential Access Method - still survives, which goes back to the early days of mainframe database. Algorithms do have a much longer shelf life than hardware. I bet you can't find any reference to "magnetic core" these days except in computing history articles, which isn't something older than ISAM.
Subscribe to:
Posts (Atom)