At 03:32 PM 23/11/2003 +0000, Gediminas wrote:

>is it possible manually to set keylinks to a column from the stored
>procedure?
>
>select * from stored_procedure;
>
>now there is only way to set KeyLinksAutoDefine to true.

Review the source of the SP and make sure that the identifier completely
matches the output column in the RETURNS clause. For example, if you made
the SP
create procedure stored_procedure (xyz integer)
returns (id integer, data varchar(20)
as ...

Then the KeyLinks column is ID or id, but not "ID".

Use a proper SELECT statement, not select *. That way, if you have been
making errors because of wrong column name references, you will get the
error during the Prepare in the dataset editor and can fix the problem at
source.

Just set the KeyLinks property directly in the property editor as usual:
"ID"
(or whatever the output column's real name is)

>So how to set
>column to invisible, if it comes from the stored procedure (for
>example "ID" column) - if I set "ID"=F or ID=F there is no result

My guess is that your SPs output fields are not named as you think they
are. Setting the FieldsVisible property is no different to any other query.

You would help yourself a lot if you would write better problem
descriptions. I can't tell what component you are using or even whether
you are using Delphi or Builder.

Helen