[tinysql] Error with CREATE TABLE!

[taquera@sherito.org]

Hi,

I think the bug must be somewhere in DatabaseEngine used, not in the
parser. The driver class that extends "tinySQL" and implements the
method "CreateTable" must return "false" in "CreateTable" as no resultset
is created in this operation.
But as far as I can see both Dbase and Text driver return
false in any case (or throw an Exception), so do you use an different
driver implementation? If so, please check that the correct value is
returned on those functions.

true means that a resultset has been created, and false that an
updatecount is available. This behaviour is the same as
Statement.execute() implements.

Have more fun,
said Thomas

--

They said Windows 95 or better, so I put it on linux. :)
On Mon, 23 Sep 2002, Edson Alves Pereira wrote:

>   Hello folks, i´m here again! Ok dudes, all I want to say is, i´ve just found a error while i tried create a table with the lastest tinySQL´s vesion, follow the exception below:
>
> D:\tmp>java example2
> ORG.as220.tinySQL.tinySQLException: Statement returned an UpdateCount
> create table edson (    ORIGEM     CHAR( 7 ),                               DTMOV      DATE,                            PLANO      CHAR( 4 ),
>                         BORDERO    CHAR( 6 ),
>                         VALENTLOJ  NUMERIC( 15, 2 ),
>             VALDESP    NUMERIC( 15, 2 ),
>                         DTPRORROGA DATE )
>  at ORG.as220.tinySQL.tinySQLStatement.executeQuery(tinySQLStatement.java:149)
>  at appi.sql.ConectorDB.Query(ConectorDB.java:92)
>  at example2.main(example2.java:56)
>
>   I´ll try to fix this error on weekend, but I think that the parser aren´t OK at all.
>
>
>   With best wishes,
>   Edson Alves Pereira
> --
> ///////////////////////////////////////
> Better well done than well said.
>  --//--
> To follow the path:
> look to the master,
> follow the master,
> walk with the master,
> see through the master,
> become the master.
>
> Modern Zen poem
> ///////////////////////////////////////
>
>
> __________________________________________________________________
> The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp
>
> Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
> _______________________________________________
> tinysql mailing list
> tinysql@as220.org
> http://as220.org/mailman/listinfo/tinysql
>