Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 9 of 9 total |
Adding new fields |
Tue, May 16 2006 10:55 AM | Permanent Link |
I have a TDBISAMQuery and I need to add some calculated fields before the
table is opened. I can do this, but then I get no "standard" fields. Is there something I can do to tell it to prepare the standard fields before I then add my calculated fields please? /Matthew Jones/ | |
Tue, May 16 2006 11:27 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Matthew
I think you've hit the problem that when persistent fields are defined they are the only ones shown. So you'll either need to define ALL of the fields in the query, or, if possible, generate your calculated fields as part of the query using sql. The latter would be faster, and you wouldn't need to define any persistent fields at all then. Roy Lambert |
Tue, May 16 2006 11:43 AM | Permanent Link |
Okay, I'll suffer it then. I've found that opening the query makes it
work, but that doesn't feel so nice. 8-) I'd like to be able to do it in SQL, but the calculated fields are things like rounding. /Matthew Jones/ | |
Tue, May 16 2006 11:46 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Matthew
So what! If you're using V4 create a custom function - they're greaaaaaat as Tony the Tigger used to say Roy Lambert |
Tue, May 16 2006 12:13 PM | Permanent Link |
Perhaps I should learn about them then... 8-)
/Matthew Jones/ | |
Tue, May 16 2006 12:19 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Matthew
If you want some help let me know, but they are dead easy to knock up - just regular OP. Roy Lambert |
Wed, May 17 2006 5:24 AM | Permanent Link |
Actually, I'd appreciate a pointer on where I can learn about such,
assuming I can use them on local databases too. I can't see anything in the table of contents. Nope - it is near the beginning - page 45. TVM. /Matthew Jones/ | |
Wed, May 17 2006 5:40 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Matthew
1. I never use the table of contents - I use the pdf manual and find mostly 2. email me an example of what you want to achieve and I'll knock up a demo for you. Roy Lambert |
Wed, May 17 2006 4:11 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Matthew,
<< Actually, I'd appreciate a pointer on where I can learn about such, assuming I can use them on local databases too. I can't see anything in the table of contents. Nope - it is near the beginning - page 45. TVM. >> It is under "Customizing the Engine": http://www.elevatesoft.com/dbisam4d5_customizing_engine.htm "Custom SQL and Filter Functions" -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, May 14, 2024 at 07:14 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |