CREATE TABLE problem

Article View: borland.public.cppbuilder.database.ado

Article #3559

Back to borland.public.cppbuilder.database.ado Previous Next

#3559

From: Ola Eriksen
Date: Thu, 01 Aug 2002 11:30

25 lines
1580 bytes

Hi there!

I'm using C++ Builder 5 and a Access database.

I'm trying to create a table with this code:

      QueryStation->SQL->Add("Create Table Cust_Groups ");
      QueryStation->SQL->Add("(");
      QueryStation->SQL->Add("  Cust_Group_ID Int Identity Primary
key,");
      QueryStation->SQL->Add("  Cust_Group_Name VarChar(30) Unique Not
null,");
      QueryStation->SQL->Add("  Cust_Group_Comments Text,");
      QueryStation->SQL->Add(")");
      QueryStation->ExecSQL();

...but I resive an exception error "Syntax error in field definition"
What's wrong with my field definition?

I've managed to create the table without any fields... (just:   CREATE
TABLE Cust_Groups)

Thank's in advance

Ola

Technical Details

Message-ID: <3D491BBA.489C88F5@callcom.no>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,3712af9d711884ff,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-08-01 03:36:53 PST
Message-ID: <3D491BBA.489C88F5@callcom.no>
Date: Thu, 01 Aug 2002 12:30:02 +0100
From: Ola Eriksen <ola@callcom.no>
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: CREATE TABLE problem 
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 217.199.52.30
X-Trace: dnews 1028197820 217.199.52.30 (1 Aug 2002 03:30:20 -0700)
Lines: 26
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews!not-for-mail