Re: ADOTable IsIndexField not returning correct result

What database are you using?

With RDBMSs like MSSQL the metadata such as that is not typically 'sent
along' to the client. If you (the client) needs to know index/primary key
info, you can query the various system tables. If you are using MSSQL, Books
Online has all the info you need.

Good luck
krf

"Nirmal Singh" <nirmal.singh@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:48316658$1@xxxxxxxxxxxxxxxxxxxxxxxxx
I am having trouble finding the primary key fields in an ADOTable.

I am using the IsIndexField propery but for some reason it always returns
false.

Any ideas why? Or, any workarounds?

Nirmal Singh



.

Relevant Pages

  • Re: ADOTable IsIndexField not returning correct result
    ... With RDBMSs like MSSQL the metadata such as that is not typically 'sent ... If you (the client) needs to know index/primary key ... If you are using MSSQL, ...
    (borland.public.delphi.database.ado)
  • Re: Hiding Comments from others in a Word doc
    ... that this sort of metadata doesn't get to the client is to send a hard paper ... to create a PDF of the file and secure the PDF. ... exclude certain types of metadata from the PDF. ...
    (microsoft.public.word.docmanagement)
  • Re: Why must NFS access metadata in synchronous mode?
    ... ...and how many NFS implementations have you seen based on ... NFS permissions are checked by the _server_, not the client. ... I don't think Ext3 must synchronously write metadata (I will ... The page will be flushed to disk afterward. ...
    (Linux-Kernel)
  • Re: OWC11 with Vb.Net
    ... the client, it will render as a pivot table. ... This function calls into the server which connects to the pivot ... pulls its data from mssql.. ...
    (microsoft.public.office.developer.web.components)
  • Connect to Remote SQL
    ... * If the client does not already have MSSQL running on their network, ... this will be taken care of by my setup package at the end of the ...
    (microsoft.public.sqlserver.tools)