On Wed, 20 Sep 2006, Martin Jenkins wrote:
You don't *have* to use the CLI to create the database, you can do it from any language that has a binding for SQLite. That's why I showed what the equivalent commands were in the CLI and for pysqlite. Sorry if it wasn't useful.
Martin, I'm working from the command line to test syntax before testing within the application. What I'm trying to figure out now is why the tables are created, but not the triggers. Need to speed up my reading to learn what I have incorrect here. The triggers are necessary to retain referential integrity during deletes, and the code came from the pysqlite wiki, so I do need to figure what's wrong. Within the application -- an approximate reasoning model we use for environmental impact assessments -- the first step is to name the project and check for an existing sqlite database. If none exists with that project name, then the sql code is executed to set up the tables and load some data. It's easier for me to test the syntax from the command line than to try to figure out if the errors are sql, sqlite, or python. Thanks very much, Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc.(TM) | Accelerator <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
