Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread MasterDetail Table Problems
Thu, Mar 18 2021 8:48 AMPermanent Link

stacho

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
Thu, Mar 18 2021 8:54 AMPermanent Link

stacho

Sorry forget
here the simple select command for Table Ansprechpartner:

SELECT * FROM "Ansprechpartner"
Thu, Mar 18 2021 10:23 AMPermanent Link

Huseyin Aliz

myBiss ApS

Avatar

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"
>
Thu, Mar 18 2021 11:10 AMPermanent Link

stacho

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"
>
Thu, Mar 18 2021 12:02 PMPermanent Link

stacho

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)
Image