I commited the PEAR standard back with these changes:
sqlImport does not create the sequence table anymore as the creation
automatically adds a 1 (ie the next insert is slotted to 2).
This means any inserts in your install.sql will need to have their id's
set (for now until I rewrite the import function)
sqlInsert still does not require a column name for sequencing. It will
detect it automatically. So a standard insert now looks like:
$core->sqlInsert($row_values, "table_name");
If a PRIMARY index exists, it becomes the column name. If one doesn't
exist, then the sequencer is skipped altogether.
Lock rules still apply. Don't lock a table before you go into the insert.
I have performed an install and everything APPEARS ok. Let me know if you
find anything. Also, if someone can test other databases, please do so.
Later,
Matt
Matthew McNaney
Internet Systems Architect
Electronic Student Services
Email: ma...@tu...
URL: http://phpwebsite.appstate.edu
Phone: 828-262-6493
ICQ: 141057403
|
