Thanks pal. Anyway, I still failed to create a table. My SQL stmt is "CREATE TABLE policy (id varchar, status varchar)" and the error I get is Zope Error Zope has encountered an error while publishing this resource. exceptions.AttributeError Sorry, a Zope error occurred. Traceback (innermost last): File /usr/local/src/Zope-2.0.0a1-src/lib/python/ZPublisher/Publish.py, line 255, in publish_module File /usr/local/src/Zope-2.0.0a1-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/local/src/Zope-2.0.0a1-src/lib/python/BoboPOS/TJar.py, line 281, in commit File /usr/local/src/Zope-2.0.0a1-src/lib/python/BoboPOS/TJar.py, line 200, in maybe_commit_objects AttributeError: _p_changed Pls help. T.Q. -----Original Message----- From: Martijn Pieters [SMTP:mj@antraciet.nl] Sent: Friday, June 25, 1999 9:53 AM To: Paul Chung Chee Soong; zope-dev Subject: Re: [Zope-dev] Z SQl Method (Newbie) At 11:53 25/06/99 , Paul Chung Chee Soong wrote:
Create a Z Gadfly Database Connection. I created a directory 'test' in Zope-2.0.0a1-src/var/gadfly and it appeared in the Data Source field. How can I access it thru SQL Method since it isn't a database at all (just a plain dir !!). Can I create a database or table via SQL Method?
Do I need to link the data source with a gadfly database? If yes, how??
By default, there's a demo data source. How can I use it????? How do I know what are the tables in it anyway?? Thus, I can't use the SQL Method.
I would appreciate very much if you can reply as soon as possible. I need to use SQL Method desperately now.
No tables have been defined yet. You can create tables using a SQL method, using standard Data Definition Language syntax: CREATE TABLE <tablename> (<column definition> [, <column definition>]*) x�>"'