MS SQL support is beta-quality. Only read-only operations have been tested, and I don't plan on testing RW operations myself ever (I don't have an MS SQL server to play with). The generator interface was changed to support MS SQL's ... unique way of quoting database objects...square brackets.
…ver thinks it should be lowercase.
…t always get entered.
…orking properly for log-to-screen mode.
The ORDER BY bit in findBy() has finally been implemented properly. The old-style SQL fragment is still supported too (legacy code cries), but it is deprecated and should be avoided.
…g with integer columns.
…ulled 'changes'. Pulling undid them...
There are a number of outstanding issues: * PRAGMA table_info or whatever it is doesn't work in PEAR::DB. The sqlite driver does an exec instead of a query. I had to patch the PEAR::DB driver to make it work, and even then, the key I need is not named the same as I get back in Oracle/MySQL. I don't know if they'll accept a patch for that (DB is EOL'd). MDB2 looks like it may support a better (agnostic) way of getting table metadata, but switching to that would kind of suck. The other alternative is to parse the output of SELECT * FROM sqlite_master WHERE table = 'table'. That has the CREATE statement, and since it's not terribly complicated, I *could*... But that's ugly too. * No testing done.
…re different in Oracle.
…php/ Conflicts: active_table/SqlGenerators/mysql.class.php nothing to commit (working directory clean)
* Changed a bunch of methods from private to protected so CSVIO can be fast