Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 11 to 13 of 13 total |
Calculated fields or SQL |
Mon, Jan 26 2009 12:08 PM | Permanent Link |
David Darlison | Fernando Dias wrote:
>If the "Parts" table is small, you can also use a lookup field to get parts.price, with "LookupCache" set to true. I have a lookup field in the Items table for parts.price but LookupCache is false. There are about 2000 records in the parts table. So is it better to multiply this lookup field by qty using OnCalcFields rather than SQL? David |
Mon, Jan 26 2009 12:50 PM | Permanent Link |
Fernando Dias Team Elevate | David,
But parts.price is not being cached (or even changed), so I don't see any problem here using one method or the other. -- Fernando Dias [Team Elevate] |
Mon, Jan 26 2009 1:05 PM | Permanent Link |
David Darlison | Fernando Dias wrote:
>But parts.price is not being cached (or even changed), so I don't see any problem here using one method or the other. Ok, thanks. |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |