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/

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

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/

Matthew


So what! If you're using V4 create a custom function - they're greaaaaaat as Tony the Tigger used to say

Roy Lambert

Perhaps I should learn about them then... 8-)

/Matthew Jones/

Matthew


If you want some help let me know, but they are dead easy to knock up - just regular OP.

Roy Lambert

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/

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

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