[icf-dev] temp-table lookups - Forum - OpenEdge Development - Progress Community
 Forum

[icf-dev] temp-table lookups

  • Does anyone know of a way to populate a lookup based on derived data stored in a temp-table (i.e. a procedural, client-side temp-table, not temporay tables from the temp-DB database).

    Our system is a property (as in real estate) based system. We have debtor accounts which may be directly or indirectly associated with each property via an intemediary table (there may be several association 'types', per account, to the property). I want to build a temporary table of all the account numbers (with no duplication) associated with the property (I cannot identify the account numbers with a single query - hence the need for the temp-table). I then want to base the lookup on the contents of that table.

    TIA,

    Brandon Greyvenstein

    (JDS)

    att1.html

  • Hi Brandon,

    Yes, you can use temp-tables for Dynamic Lookups and Dynamic Combos. This

    however is only available from V2 onwards. If you are running Dynamics V2

    then you are all set. Have a look at the SmartDataField Maintenance spec

    available on possenet for more details on how to implement this.

    Mark Davies

    Project Leader

    Tel: +27 (0)11 575-1836 (Direct)

    Tel: +27 (0)11 575-1800 (Switchboard)

    Fax: +27 (0)11 576-2601

    Cell: +27 (0)73 287 1254

    MIP

    2nd Floor, Zone 2

    Wrigley Field, The Campus

    Sloane Avenue, Bryanston

    -Original Message-

    From: Brandon Greyvenstein

    Sent: 03 Februarie 2003 07:15

    To: dev@icf.possenet.org

    Subject: temp-table lookups

    Does anyone know of a way to populate a lookup based on derived data stored

    in a temp-table (i.e. a procedural, client-side temp-table, not temporay

    tables from the temp-DB database).

    Our system is a property (as in real estate) based system. We have debtor

    accounts which may be directly or indirectly associated with each property

    via an intemediary table (there may be several association 'types', per

    account, to the property). I want to build a temporary table of all the

    account numbers (with no duplication) associated with the property (I cannot

    identify the account numbers with a single query - hence the need for the

    temp-table). I then want to base the lookup on the contents of that table.

    TIA,

    Brandon Greyvenstein

    (JDS)

    ______________________________________

    This e-mail may contain confidential information and may be legally

    privileged and is intended only for the person to whom it is addressed. If

    you are not the intended recipient, you are notified that you may not use,

    distribute or copy this document in any manner whatsoever. Kindly also

    notify the sender immediately by telephone, and delete the e-mail. When

    addressed to clients of the company from where this e-mail originates ("the

    sending company ") any opinion or advice contained in this e-mail is subject

    to the terms and conditions expressed in any applicable terms of business or

    client engagement letter . The sending company does not accept liability for

    any damage, loss or expense arising from this e-mail and/or from the

    accessing of any files attached to this e-mail.

  • Hi Mark,

    Thanks for the info. Do you perhaps know the link to this document on the possenet site, I can't find it.

    Thanks,

    Brandon.

    - Original Message -

    From: Mark Davies

    To: dev@icf.possenet.org

    Sent: Tuesday, February 04, 2003 4:46 PM

    Subject: RE: temp-table lookups

    Hi Brandon,

    Yes, you can use temp-tables for Dynamic Lookups and Dynamic Combos. This however is only available from V2 onwards. If you are running Dynamics V2 then you are all set. Have a look at the SmartDataField Maintenance spec available on possenet for more details on how to implement this.

    Mark Davies

    Project Leader

    Tel: +27 (0)11 575-1836 (Direct)

    Tel: +27 (0)11 575-1800 (Switchboard)

    Fax: +27 (0)11 576-2601

    Cell: +27 (0)73 287 1254

    MIP

    2nd Floor, Zone 2

    Wrigley Field, The Campus

    Sloane Avenue, Bryanston

    -Original Message-

    From: Brandon Greyvenstein

    Sent: 03 Februarie 2003 07:15

    To: dev@icf.possenet.org

    Subject: temp-table lookups

    Does anyone know of a way to populate a lookup based on derived data stored in a temp-table (i.e. a procedural, client-side temp-table, not temporay tables from the temp-DB database).

    Our system is a property (as in real estate) based system. We have debtor accounts which may be directly or indirectly associated with each property via an intemediary table (there may be several association 'types', per account, to the property). I want to build a temporary table of all the account numbers (with no duplication) associated with the property (I cannot identify the account numbers with a single query - hence the need for the temp-table). I then want to base the lookup on the contents of that table.

    TIA,

    Brandon Greyvenstein

    (JDS)

    ______________________________________

    This e-mail may contain confidential information and may be legally

    privileged and is intended only for the person to whom it is addressed. If

    you are not the intended recipient, you are notified that you may not use,

    distribute or copy this document in any manner whatsoever. Kindly also

    notify the sender immediately by telephone, and delete the e-mail. When

    addressed to clients of the company from where this e-mail originates ("the

    sending company ") any opinion or advice contained in this e-mail is subject

    to the terms and conditions expressed in any applicable terms of business or

    client engagement letter . The sending company does not accept liability for

    any damage, loss or expense arising from this e-mail and/or from the

    accessing of any files attached to this e-mail.