We bind the Delphi grid to an TADOQuery, which makes use 'select' query to retreive the data from different tables. Could the ADOQuery lock the tables?

James

Thank you. Appreciate your help.

But how do I do a "bulk insert" in a stored procedure?

Whoop, it's a typo. But

select * from fnTableFunction()

does work.

Nevertheless, accroding to the feedback I received, I will put the owner in front of all function...