Problem listing available indexes for remote DM table objects

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

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by John Graham Thu, 12 Aug 1999 00:00

#1707

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads