🚀 go-pugleaf

Serra wrote:

> }'m very sorry for disturbing you Bill
> but i dont know the partnos(AAA,BBB,CCC)  how can i get them ?
> and how can i add to my select statement

Sorry but I do not understand your question. In your last message you
said that the PARTNO is in the OrderDetail records. Here is the
OrderDetail information from your last message.

CDS (OrderDetail Table) :

PartNo  PartName  Qty   UPrice
--------------------------------------------
AAA        AAAAA      1       100
BBB        BBBBB     10      200
CCC       CCCCC    20      300

Are you saying that you do not know how to write the code to get the
PARTNO values from the OrderDetail CDS?

var
  S: String;
begin
  OrderDetailCds.First;
  while not OrderDetailCds.EOF do
  begin
    if S = '' then
      S := S + ' PARTNO = ' + 
        QuotedStr(OrderDetailCds.FieldByName('PARTNO').AsString)
    else
      S := S + ' OR PARTNO = ' + 
        QuotedStr(OrderDetailCds.FieldByName('PARTNO').AsString)
    OrderDetailCds.Next;
  end;

At the end of this code the variable S contains 

PARTNO = 'AAA' OR PARTNO = 'BBB' OR PARTNO =
'CCC'

Concatenate it to the end of the string SELECT * FROM PARTS WHERE and
you have the SQL statement to assigne to the CommandText  property of
the Parts CDS.

-- 
Bill Todd (TeamB)