>Hi all !
>how to insert mysql local table from remote table ?
>SQLEXEC(lnHandle,"insert into LocalTable.employee select * from RemoteTable.employee")

Not sure about MySQL, but in SQL Server the full name of the table is:

[Server].[DataBase].[Schema].[TableName]
So maybe in MySQL is the same:
SQLEXEC(lnHandle,"insert into LocalServer.DataBase.Schema.employee select * from RemoteServer.DataBase.Schema.employee")
But you should check for the right syntax.

Thanks ! but syntax error.....