primary index

[uffek]

How can I set the index to be the primary index for a TUniTable?
I need records to be returned in that order.

6.2.10, on D10

[AlexP]

You can use the IndexFieldNames property for sorting: https://www.devart.com/unidac/docs/?dev ... dnames.htm .

[uffek]

I don't know the name of the field(s) making up the primary key. How do I find it? Can I somehow test either the whole table or each individual field?

[AlexP]

To retrieve the key field name, you can use the TUniConnection.GetKeyFieldNames method:

Code: Select all

  lst := TStringList.Create;
  try
    UniConnection1.GetKeyFieldNames('DEPT', lst);
    for I := 0 to Lst.Count - 1 do
      ShowMessage(Lst[i]);
  finally
    lst.Free;
  end;

[uffek]

Thank, that works nicely for our oracle and postgresql database, but gives this error on mssql: "Unsupported metadata kind". Any trick there? (SQL Server 2008 R2 "express")

When looking in the documentation, I can see it was a new function in 5.5, but it is not listed otherwise.

[uffek]

Solved: A fully qualified tablename was needed "schema.tablename".

[AlexP]

Glad to see that you solved the problem. If you have any other questions, feel free to contact us

[uffek]

This one is still open:
http://forums.devart.com/viewtopic.php?f=5&t=33107

And I hope you have made a note that documentation for GetKeyFieldNames is missing.

[AlexP]

We will add description of this method to the help shortly.