QBE Trick fails on 7 -> 8 upgrade

[Ray Glaze]

I have a form which performs the following query in its open

q = Query
ANSWER: :PRIV:ANSWER.DB

:data:ORG.DB |
CheckPlus |

EndQuery

This is a trick I used to use to get a local copy of a table. It should
generate a qbe with all of the fields checkPlus'ed. What I am getting is an
empty query. I think that I have narrowed all of the variables to the
version of Paradox. The exact form works on machines with 7 and not with 8
though that testing is limited.

This is quite distressing, as it is a trick I used a lot in the past, and I
wonder now if I need to review all of the code and change it. Before I do,
I ask for help!

Thanks.
Ray

[Ray Glaze]

Further testing belies my prior assertion!

The code works the same in both versions (whew!). However, the evidince I
used is faulty. The qbe generated by q.writeqbe() gives a blank query in
this case. I had not seen that before.

for completeness:

method run(var eventInfo Event)
var
q Query
tbl Tableview
endvar

q =
Query
ANSWER: :PRIV:ANSWER.DB

test.db |
Check |

EndQuery

errortraponwarnings(yes)
try
q.WriteQBE( "Test")
q.executeqbe()
tbl.open(":Priv:Answer")

onfail
errorshow()
endtry

endMethod

I appologize for any anxiety I caused!

Ray Glaze <rgl...@nmt-inc.com> wrote in message
news:92645076...@news.remarQ.com...