Hey, TEAMB...Need some real help with TTable and CreateTable in SQL Back end

Article View: comp.lang.pascal.delphi.databases

Article #81

Back to comp.lang.pascal.delphi.databases Previous Next

#81

From: Bill Artemik
Date: Sun, 29 Nov 1998 00:00

31 lines
1948 bytes

I am using Delphi 3.0 and need to create an InterBase 5 table.

I am using a TTable component and have populated the FieldDefs
property. When I call the CreateTable method things work fine. When I
include a IndexDefs statement (IndexDefs.Add('','Field1',[ixUnique])
and call the CreateTable method I get an error "INvalid Index/Tag
name". Where is this coming from and how do I fix it? I have to create
2 indexes (one primary and one secondary) and can't seem to get around
this. I cannot use TQueries here...need on a TTable. When I run the
same thing against Paradox it works just fine.

Any help on fixing this is greatly appreciated!

Thanks!
----
Bill
------------------------
artemik@worldnet.att.net
bartemik@neri.org
Programmer / Analyst
New England Research Institutes

"I believe that five out of 
     four people have trouble with fractions."

             <?>

           \\\|///
          \\ ~ ~ //
           ( @ @ )
/-------oOOo-(_)-oOOo--------\

Technical Details

Message-ID: <36620782.22465245@news1.newscene.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,870fac23abe7341d,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: 10de66,870fac23abe7341d,start
X-Google-Attributes: gid10de66,public
X-Google-Thread: ff75c,870fac23abe7341d,start
X-Google-Attributes: gidff75c,public
X-Google-Thread: 1043cf,870fac23abe7341d,start
X-Google-Attributes: gid1043cf,public
From: artemik@worldnet.att.net (Bill Artemik)
Subject: Hey, TEAMB...Need some real help with TTable and CreateTable in SQL Back end
Date: 1998/11/29
Message-ID: <36620782.22465245@news1.newscene.com>
X-Deja-AN: 416952710
Content-Transfer-Encoding: 7bit
Organization: New England Research Institutes
Content-Type: text/plain; charset=us-ascii
MIME-Version: 1.0
Reply-To: artemik@worldnet.att.net
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.desktop,borland.public.delphi.database.sqlservers,borland.public.delphi.objectpascal