Problem listing available indexes for remote DM table objects

Article View: borland.public.cppbuilder.database.multi-tier

Article #1707

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#1707

From: John Graham
Date: Thu, 12 Aug 1999 00:00

21 lines
1398 bytes

Folks,

I ran into something interesting involving remote data module table
objects.  We have two identical MS SQL Server databases, one running
under MS SQL Server 6.5 and the other running under MS SQL Server 7.0.

My 3T application does a search for a primary key value, "Code" in the
"Site" table and returns a single record to the corresponding
ClientDataSet.  This works fine with MS SQL 6.5, but throws a "No index
on field 'Code'" exception on the MS SQL 7.0 database.

Furthermore, I can list the available database table indexes in the app.
server's remote data module table object's IndexName property for the MS
SQL 6.5 database, but not for the MS SQL 7.0 database.  I know they're
there because I can see them using SQL Explorer as well as the
Enterprise Manager for MS SQL 7.0.

Anybody got a clue?

Thanks,
John

Technical Details

Message-ID: <37B2B1BD.FA331626@salts.navy.mil>

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: fcd2b,29c8f49a4df29463,start
X-Google-Attributes: gidfcd2b,public
From: John Graham <jgraham@salts.navy.mil>
Subject: Problem listing available indexes for remote DM table objects
Date: 1999/08/12
Message-ID: <37B2B1BD.FA331626@salts.navy.mil>
X-Deja-AN: 511815009
Content-Transfer-Encoding: 7bit
Organization: U. S. Navy SALTS Project
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier