FW: [icf-dev] temp-table lookups

Thanks Mark!

This feature is very useful, however, I would need to send two input parameters (i.e. an 'owning_entity_mnemonic' and an 'owning_object_ID' to identify the parent values) to the 'temp-tableData' procedure (the one that populates the temp-table) in order to retrieve only a subset of records from the relevant database . Without these parameters, 'temp-tableData' would take to long to build the temp-table for the lookup.

It appears that the call to 'temp-tableData' only makes provision for a single output parameter i.e. the table handle. Is this in fact the case?, if so, do you know of a work around?

TIA,

Brandon Greyvenstein.

- Original Message -

From: Mark Davies

To: ICF Dev2

Sent: Wednesday, February 05, 2003 12:25 AM

Subject: FW: temp-table lookups

Sorry this took so long, but I was trying to send the actual document, but the server kept on rejecting it.

Anyway, here is the link:

http://docs.possenet.org/project_documents/icfdocs.html

Find the SmartDataField Maintenance Functional Specification.

See Section 3.12 - Page 41

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: 04 Februarie 2003 12:32

To: dev@icf.possenet.org

Subject: Re: temp-table lookups

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.

______________________________________

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,

There is an issue logged to have this implemented. Look at the suggestions

made in issue 8513.

If it is at all possible, you could make use of the setUserPropery functions

to set your value and then retrieve this value in your temp-table plip

later.

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: 04 Februarie 2003 06:54

To: dev@icf.possenet.org

Subject: Re: temp-table lookups

Thanks Mark!

This feature is very useful, however, I would need to send two input

parameters (i.e. an 'owning_entity_mnemonic' and an 'owning_object_ID' to

identify the parent values) to the 'temp-tableData' procedure (the one that

populates the temp-table) in order to retrieve only a subset of records from

the relevant database . Without these parameters, 'temp-tableData' would

take to long to build the temp-table for the lookup.

It appears that the call to 'temp-tableData' only makes provision for a

single output parameter i.e. the table handle. Is this in fact the case?, if

so, do you know of a work around?

TIA,

Brandon Greyvenstein.

- Original Message -

From: Mark Davies To: ICF Dev2 Sent: Wednesday, February 05, 2003 12:25 AM

Subject: FW: temp-table lookups

Sorry this took so long, but I was trying to send the actual document, but

the server kept on rejecting it.

Anyway, here is the link:

http://docs.possenet.org/project_documents/icfdocs.html

Find the SmartDataField Maintenance Functional Specification.

See Section 3.12 – Page 41

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: 04 Februarie 2003 12:32

To: dev@icf.possenet.org

Subject: Re: temp-table lookups

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.

______________________________________

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.

______________________________________

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.