Hi, All.
Boy am I glad I've found this echo! Hope you guys can help with a couple
of small  problems.
This is PdoxWin. I have a relatively simple script which runs a few
queries and presents the results to the user (me) as the final table. We
have ORDERs and TRADEs (& some other ones, irrelevant to this
discussion). An ORDER will be for a certain quantity of shares and this
may take many TRADEs before the order is complete. I need to find out
which orders are unfilled, ie the total quantity of the trades is less
than the quantity ordered.
Simple? Of course!
However, I want to show the quantity ordered, and the quantity
remaining, as whole numbers and Paradox's default is 2 decimal places.
Still simple? Of course, just
  TV.Ordered.NumberFormat = "W.0,ENWDWLW"
(and how long did it take to find NumberFormat in the docs & help file?
Terrible documentation.)
TV is a TableView and that works fine, Ordered is the field which
originally comes from a DB after going through several queries.
BUT, Unfilled is a field which is calculated by the query, and you can't
do that - you get a run-time error! Doing an EnumObjectProperties on the
table which results from the last query tells me that it's *not* a
numeric field, so setting NumberFormat is an illegal operation. And you
can't set FieldType, it's a read-only property.
So, guys, how do I do this?
Second problem, after I've looked at my outstanding orders I just want
to close the table and go away. But I get a "The view properties of this
table have been changed" dialog box, because I've changed
Ordered.NumberFormat. Annoying. How do I tell it that I'm not interested
in that change?
Regards, FIM.
 * * Money Talks!  Mine always says goodbye!
---
---------------