Lock table in query

[mauricionava]

hello
I created a query with a table that cannot be edited. How can I lock the query so users cannot edit the table thru the query?

thanks

 

[PHV]

Simply use the DISTINCT predicate in the SQL code.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mauricionava]

Great. Thanks.

I did not know I could use that to lock tables thru queries.