Query Q

[Anders E]

I know this newsgroup is for Paradox8, but I posted this in
comp.databases.paradox and i didn't get any clues to the problem....so I
thought i'll give it a try here too :-)
...............................................
Hi!
I have this problem which I will try to describe...my english might not
be that good, but hey - i'll give it a try ;-)
I have a form containing a table frame (source: tabel.db) and three
drop-down menues. The content of each drop-down menue corresponds to a
given field in the table.db. By selecting a record in a drop-down menue
the other two menues will contain the corresponding field values i.e
filtering (although I do this with a query). My problem is that I want
the tabel frame (i.e) to show the records that correspond to the
selected values in the drop-down menues. I have tried to do this by
executing a query with the drop-down field values as tilde-variables,
and with table.db as the output of the query:

que.executeQBE("tabel.db")

now - this can't be done because the "table.df is already in use" - it's
open in the form, right. I could use a filter on the table but since
Paradox 7 doesn't seem to be able to filter with values such as:
045.3465B or G/H 456,78T.6 (and field contens like that will defenatly
show up in the table) my only(?) solution seems to be to use a query.
Now - is there a way to do a query with the result being put in an
already open table? Is there some "lock - propery" or something that I
have missed? Or can you override the limits of the filter in some way? I
have thought of putting the query result in a temporary table (answer.db
perhaps) and then use that table as a "mask" or a filter on
table.db...is this possible?
I would appriciate any suggestions or hints to my problem!

Best Regards, Anders

----------------------------------------------------------------
Anders Engström
nge9...@NO-SPAMstudent1.lu.se [remove NO-SPAM]
Student at the Department of Physical Geography, Univ. of Lund
Lund, Sweden
http://aztak.ml.org/
REMEMBER==> NO BULL!!
----------------------------------------------

[Paul O'Hagan]

Mr. Engström,

You might be able to do it by associating the table frame to the Answer.db,
and everytime a new sort is done use the UIObject.forceRefresh() method.

Regards,
Paul O'Hagan
Corel Paradox Technical Services