Pedro, I think that gadfly doesn't require (support?) the use of sizes in varchar types, change your sql to:- CREATE TABLE registos( id INT, nome VARCHAR, apelido VARCHAR, morada VARCHAR, localidade VARCHAR, casa INT, telemovel INT, data_nasc VARCHAR ) Phil phil.harris@zope.co.uk | -----Original Message----- | From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Pedro | Silva | Sent: Wednesday, February 23, 2000 11:07 AM | To: Zope - Questions | Subject: [Zope] Gadfly databases syntax | | | Hi, | | I'm using a Gadfly database connection to create Z SQL Methods. | This is the | first time that I'm using this, and because I know a little of | SQL, it seams | that are some differences between Ansy SQL and Z SQL. | | Now, I'm trying to create a table with the following code: | | CREATE TABLE registos( | id INT, | nome VARCHAR(10), | apelido VARCHAR(10), | morada VARCHAR(50), | localidade VARCHAR(30), | casa INT, | telemovel INT, | data_nasc VARCHAR(10) | ) | | When I push the button "Change and Test", it shows a message "The query | requires no input". Then after I push the "Submit Query" button, | it gives me | a Syntax Error, so I figure that only could be the syntax that | this SQL use | is differente from the normal SQL. | | Could anyone tell me the diffrences and/or tell me where I can | go to see the | differences? | | Please send your answers to: psilva@ruido-visual.pt | | Thanks, | | Pedro | | PS - I'm sending to you too, because I know that you must know something | about this and would be quicker, I hope!!! | | | | | _______________________________________________ | Zope maillist - Zope@zope.org | http://lists.zope.org/mailman/listinfo/zope | ** No cross posts or HTML encoding! ** | (Related lists - | http://lists.zope.org/mailman/listinfo/zope-announce | http://lists.zope.org/mailman/listinfo/zope-dev ) |