Hi,
  I'm using a TEDBQuery with SQL like this: "select tblA.*, tblB.field as MyField from tblA join tblB on tblA.ID = tblB.ID order by MyField"

The query works fine but I need to add TField at design time to evaluate a calc field with a result of an external function (a automatic barcode for
example).

But I have this problem:
if I add TFields I can't access to MyField; If I remove Tfields I can't evaluate my calc field...

What's the solution that I don't find?? ^^

Thanks

Dario

No idea?? ^^

Dario B wrote:

Hi,
  I'm using a TEDBQuery with SQL like this: "select tblA.*, tblB.field as MyField from tblA join tblB on tblA.ID = tblB.ID order by MyField"

The query works fine but I need to add TField at design time to evaluate a calc field with a result of an external function (a automatic barcode for
example).

But I have this problem:
if I add TFields I can't access to MyField; If I remove Tfields I can't evaluate my calc field...

What's the solution that I don't find?? ^^

Thanks

Dario

Dario


Saying you're adding TFields are you saying that you've added some persistent fields to the query or something else?

If that is what you're saying have you tried adding MyField to the field list?

Roy Lambert [Team Elevate]

Dario,

<< But I have this problem:
if I add TFields I can't access to MyField; If I remove Tfields I can't
evaluate my calc field... >>

Could you please elaborate on how you're creating the persistent TFields,
and which TFields are being created ?  Using the fields editor, adding all
of the dataset fields automatically should result in the necessary
persistent TFields being created.

--
Tim Young
Elevate Software
www.elevatesoft.com

I have understood!

If I write my SQL query in my TEDBxQuery I can add the TFields at design time;
If I change SQL Query at runtime I have to create my fields by myself..

NOw I have understood and everything works fine

thank you

Dario

"Tim Young [Elevate Software]" wrote:

Dario,

<< But I have this problem:
if I add TFields I can't access to MyField; If I remove Tfields I can't
evaluate my calc field... >>

Could you please elaborate on how you're creating the persistent TFields,
and which TFields are being created ?  Using the fields editor, adding all
of the dataset fields automatically should result in the necessary
persistent TFields being created.

--
Tim Young
Elevate Software
www.elevatesoft.com