Pedro, If your using GadFly try substituting INTEGER for INT Make your query look like this: CREATE TABLE Registos (Nome VARCHAR, Apelido VARCHAR, Morada VARCHAR, Localidade VARCHAR, Casa INTEGER, Telemovel INTEGER, Data_nasc VARCHAR) This works (tested 8¬/). HTH Phil phil.harris@zope.co.uk ----- Original Message ----- From: "Pedro Silva" <psilva@ruido-visual.pt> To: "Zope - Questions" <zope@zope.org> Sent: 28 February 2000 18:17 Subject: [Zope] Zope SQL Method
Hi Zopits,
I'm trying to use the Z SQL Method to create a table. I have the following code in that:
CREATE TABLE Registos (Nome VARCHAR(10), Apelido VARCHAR(10), Morada VARCHAR(50), Localidade VARCHAR(30), Casa INT, Telemovel INT, Data_nasc VARCHAR(10))
When I push the Submit Query button, it gives me a error: "Syntax Error".
Where could that syntax error be? I already looked to the code and I fine him right, so I can't figure where the error could be.
Can anyone help me on this?
Please send your answers to: psilva@ruido-visual.pt
Thanks,
Pedro
_______________________________________________ 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 )