From: Mark DaviesTo: ICF Dev2Sent: Wednesday, February 05, 2003 12:25 AMSubject: FW: [icf-dev] temp-table lookupsSorry 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 [mailto:brandon@jds.co.za]
Sent: 04 Februarie 2003 12:32
To: dev@icf.possenet.org
Subject: Re: [icf-dev] 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 -----
Sent: Tuesday, February 04, 2003 4:46 PM
Subject: RE: [icf-dev] 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 [mailto:brandon@jds.co.za]
Sent: 03 Februarie 2003 07:15
To: dev@icf.possenet.org
Subject: [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)
______________________________________This e-mail may contain confidential information and may be legallyprivileged and is intended only for the person to whom it is addressed. Ifyou are not the intended recipient, you are notified that you may not use,distribute or copy this document in any manner whatsoever. Kindly alsonotify the sender immediately by telephone, and delete the e-mail. Whenaddressed to clients of the company from where this e-mail originates ("thesending company ") any opinion or advice contained in this e-mail is subjectto the terms and conditions expressed in any applicable terms of business orclient engagement letter . The sending company does not accept liability forany damage, loss or expense arising from this e-mail and/or from theaccessing 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.