Hello

is there an Example like the Master-Detail Example in EWB2?

My Problem:

2 Tables; "Kunden" and "Ansprechpartner" 1 to n relation

Tables are from a MSAccess DB

Changing Row in "Kunden"  shoud show Rows from "Ansprechpartner in a Grid

This dont work

The Select command in "Ansprechpartner" is

procedure TEDLDatabase.LoadKundenAnsprechpartner;
begin
  Ansprechpartner.Params.Clear;
  Ansprechpartner.Params.Add('KundenID='''+Kunden.Columns['KundenID'].AsString+'''');
  LoadRows(Ansprechpartner);
end;

The Grid shows always all Rows

Thank You for Help

Sorry forget
here the simple select command for Table Ansprechpartner:

SELECT * FROM "Ansprechpartner"

Hi,

I think you need something like:

SELECT * FROM "Ansprechpartner" WHERE KUNDENID={KUNDENID='1111'}

Regards
Huseyin



Den 18-03-2021 kl. 13:54 skrev stacho:
> Sorry forget
> here the simple select command for Table Ansprechpartner:
>
> SELECT * FROM "Ansprechpartner"
>

that is the Question.

in EWB2 in works with setting Param Property in in Dataset (like procedure in my first post)
In EWB3 there is the Select.Command but i dont know how to change the select command at runtime

Huseyin Aliz wrote:

Hi,

I think you need something like:

SELECT * FROM "Ansprechpartner" WHERE KUNDENID={KUNDENID='1111'}

Regards
Huseyin



Den 18-03-2021 kl. 13:54 skrev stacho:
> Sorry forget
> here the simple select command for Table Ansprechpartner:
>
> SELECT * FROM "Ansprechpartner"
>

I have made a mistake

So it Works

Select command:

SELECT * FROM "Ansprechpartner"
WHERE KundenID = :KundenID

Then the procedure

procedure TEDLDatabase.LoadAnsprechpartner;
begin
 Ansprechpartner.Params.Clear;
 Ansprechpartner.Params.Add('KundenID='+Kunden.Columns['KundenID'].AsString);
 LoadRows(Ansprechpartner);
end;

The Mistake: i fired the procedure LoadAnsprechpartner before Kunden Dataset was created - (stupid)