[Zope-dev] Z SQl Method (Newbie)

Martijn Pieters mj@antraciet.nl
Fri, 25 Jun 1999 09:52:34 +0200


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>]*)

--
Martijn Pieters, Web Developer
| Antraciet http://www.antraciet.nl
| Tel: +31-35-7502100 Fax: +31-35-7502111
| mailto:mj@antraciet.nl http://www.antraciet.nl/~mj
| PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149
------------------------------------------