BorlandTalk.com

Chris W · Guest

I have a simple single parameter TQuery object with code that looks like
this ..

KeysQ->Active = False;
KeysQ->ParamByName("TableName")->AsString = "Usage";
KeysQ->Active = True;

and a query text that looks like this..

select * from keys where TableName = :TableName;

why does this code not reflect changes made to the database by other
applications using the same table? BTW the table is a paradox table and
local share is set to true. If I bring up another form that has a
simple table view of the keys table and use the DBNavigator's refresh
button, then go back to the form that executes that code it works other
wise it does not. Why is that?

Chris W

Gift giving made easy with The Wish Zone
Get the gifts you want and give the gifts they want!
One stop wish list for any gift, from anywhere, for any occasion!
http://www.thewishzone.com