Subject | Re: [ib-support] Re: problems width storing data |
---|---|
Author | Helen Borrie |
Post date | 2002-10-16T10:40:25Z |
At 10:31 AM 16-10-02 +0000, djordje wrote:
Your previous statement:
(table users has columns(int(5), varchar(30), varchar(30))
indicates that possibly you tried an invalid SQL statement to create your
table. It should be
CREATE TABLE USERS (
field1 integer,
field2 varchar(30),
field3 varchar(30));
Firebird doesn't have a type int(5).
If you are sure the table is present, then I recommend you take your
problem to the firebird-java list, where the Jaybird people can help you
with any driver problems...
Join at http://www.yahoogroups.com/community/firebird-java
heLen
>no I had never used one of these tools, I'm just trying to insert itIt is not clear that you have a valid table into which to insert.
>width isql tool for firebird, I have JDBC drivers for firebird and i
>made a simple sql tool but it's not working I get a message unable to
>insert. I beleve it's same problem like width isql. \
Your previous statement:
(table users has columns(int(5), varchar(30), varchar(30))
indicates that possibly you tried an invalid SQL statement to create your
table. It should be
CREATE TABLE USERS (
field1 integer,
field2 varchar(30),
field3 varchar(30));
Firebird doesn't have a type int(5).
If you are sure the table is present, then I recommend you take your
problem to the firebird-java list, where the Jaybird people can help you
with any driver problems...
Join at http://www.yahoogroups.com/community/firebird-java
heLen
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/