How to Lock the table / file when update,insert,delete the record through the ODBC

[ZhenLung]

I Using the below command to update,insert,delete the record

=SQLEXEC(ODBCHandle,"Update Customer SET Name = ?LvName Where CusID = ?LvID")

=SQLEXEC(ODBCHandle,"INSERT INTO Customer (Name) Values (?LvName)")
=SQLEXEC(ODBCHandle,"DELETE From Customer WHERE CusID = ?LvID")

I'm using the SQL Server 7 Database and Visual FoxPro Front

It anyone know during the updating,inserting and deleting the record, how
to lock the remote table and also unlock.

Thank

[Anders Altberg]

"ZhenLung" <zhenlung@yahoo.com> wrote in message
news:3a7b739e$1@news.devx.com...
>
> I Using the below command to update,insert,delete the record
>
> =SQLEXEC(ODBCHandle,"Update Customer SET Name = ?LvName Where CusID =
?LvID")
>
> =SQLEXEC(ODBCHandle,"INSERT INTO Customer (Name) Values (?LvName)")
> =SQLEXEC(ODBCHandle,"DELETE From Customer WHERE CusID = ?LvID")
>
> I'm using the SQL Server 7 Database and Visual FoxPro Front
>
> It anyone know during the updating,inserting and deleting the record, how
> to lock the remote table and also unlock.
>
> Thank
>
SQL Server handles it automatically.

-A