Return-Path: X-Original-To: apmail-incubator-ooo-issues-archive@minotaur.apache.org Delivered-To: apmail-incubator-ooo-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 5525A962D for ; Wed, 16 Nov 2011 19:56:39 +0000 (UTC) Received: (qmail 11050 invoked by uid 500); 16 Nov 2011 19:56:39 -0000 Delivered-To: apmail-incubator-ooo-issues-archive@incubator.apache.org Received: (qmail 11012 invoked by uid 500); 16 Nov 2011 19:56:39 -0000 Mailing-List: contact ooo-issues-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ooo-issues@incubator.apache.org Delivered-To: mailing list ooo-issues@incubator.apache.org Received: (qmail 11004 invoked by uid 99); 16 Nov 2011 19:56:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Nov 2011 19:56:39 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.123] (HELO sif.zones.apache.org) (140.211.11.123) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Nov 2011 19:56:36 +0000 Received: by sif.zones.apache.org (Postfix, from userid 80) id 9022C2E83; Wed, 16 Nov 2011 19:56:15 +0000 (UTC) From: bugzilla@apache.org To: ooo-issues@incubator.apache.org Subject: DO NOT REPLY [Bug 118588] Cannot create new data tables in existing database Date: Wed, 16 Nov 2011 19:56:10 +0000 X-Bugzilla-Reason: CC X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Database access X-Bugzilla-Component: none X-Bugzilla-Keywords: X-Bugzilla-Severity: major X-Bugzilla-Who: brian.tye@care4free.net X-Bugzilla-Status: UNCONFIRMED X-Bugzilla-Priority: P5 X-Bugzilla-Assigned-To: dbaneedsconfirm@openoffice.org X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: X-Bugzilla-URL: https://issues.apache.org/ooo/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/ooo/show_bug.cgi?id=118588 --- Comment #8 from Brian Tye 2011-11-16 19:56:10 UTC --- I tried the following but am hitting sytax errors: CREATE TABLE RHS_list_2012 (ID INT(4) PRIMARY KEY IDENTITY, RHSlist INT(4) NOT NULL, Yes/No BIT NOT NULL, Species TEXT(56), Sown DATE, Germinated DATE, Comments TEXT(150), Cultivation TEXT(150)) Can you help with corrections? (As you may have guessed I'm not hot on writing progs, I prefer using them!) -- Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.