Subject | Re: [IBO] Re: Field not found |
---|---|
Author | Helen Borrie |
Post date | 2005-04-12T23:31:09Z |
At 09:37 PM 12/04/2005 +0200, you wrote:
search the buffers first and then query the table if the search match is
not found. The "field not found" error then occurs when the search query
is requested.
solution is to make a view out of your joined set. Searches, filters and
KeyLinks then work "out-of-the-box". You can then either provide triggers
to make the view updatable, or you can write custom DML for the updating
operations.
Helen
>At 11:04 AM 12/04/2005 +0200, you wrote:I don't know how those controls work, but a reasonable guess is that they
>
> > I use a TwwDBGrid with programmatically filled columns:
> >
> >with MyGrid.Selected do
> >begin
> > Clear;
> > Add('DEBITOR' + #9 + '14' + #9 + 'Deb' + #9 + ');
> > Add('ARTICLE' + #9 + '16' + #9 + 'Article' + #9 + 'T');
> >end;
> >
> >I use a TwwSearchDialog with the same selected property.
> >If I use the SearchDialog and search for a not existing value then an
> >error shows up with "Column unknow DEBITOR".
>
>Correctly, since your DEBITOR field is not a database column.
>
>gh: Ok, but an existing value is no problem. How come ???
search the buffers first and then query the table if the search match is
not found. The "field not found" error then occurs when the search query
is requested.
>gh: The problem is that the fields in the join query has the sameIt's not the only option and it's surely not a good option. A clean
>name, So I need to distiguish them in the appointment of the
>Selected-property. If I don't alias them myself, then the field-editor
>does. I suppose renaming the fields in the database is the only
>option?
solution is to make a view out of your joined set. Searches, filters and
KeyLinks then work "out-of-the-box". You can then either provide triggers
to make the view updatable, or you can write custom DML for the updating
operations.
Helen