Subject | Re: [IBO] Two editable and indexed columns from two tables |
---|---|
Author | Gerard J.M.Houtenbos |
Post date | 2002-12-24T22:20:42Z |
Does the fact that knowbody has followed this thread, mean that
it is not possible?
Gerard
it is not possible?
Gerard
On Wed, 18 Dec 2002 20:14:48 +0100, you wrote:
>I do have two tables in an Interbase 6 database accessed by
>IB-Objects:
>
>Players
>P_Key: Integer;
>Name: String;
>CaptainKey: Integer;
>
>Captains
>P_Key: Integer;
>Name: String;
>
>I use a TwwDbGrid in which I need two columns:
>Players.Name
>Captains.Name
>
>There are three necessities:
>1. The Players.Name must be editable.
>2. The Captains.Name must be selectable from a LookUpCombo
>3. The grid must be indexed on either column by means of the
>TitleButtonClick-method.
>
>I tried a join-TIBOquery, but then the Captains.Name isn't
>editable.
>
>I tried to use a TIBOquery with a lookupfield for the
>Captains.Name, but then I can't index on the Captains.Name using
>OrderingItems.
>
>I tried a ClietDataSet - DataSetProvider combination connected to
>the same query with the lookupfield, but then the Captains.Name
>is not editable.
>
>How do I solve this problem?
>
>tia,
>
>
>
>_________________________
>
>Gerard J.M. Houtenbos
>DoubleWood Software
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
_________________________
Gerard J.M. Houtenbos
DoubleWood Software