I am trying to update a field in one table saved locally, by setting it to field value in another table.

Here is my code in the Paradox Script:

method run(var eventInfo Event)
var
sqlHandle Sql
dbHandle database
endvar

dbHandle.open(":Stud_Min:")
sqlHandle=Sql

update "table1.db" set "table1.db".dates = "table2.db".dates
where "table1.db".people_id="table2.db".people_id
endSql

try
sqlHandle.executeSql(dbHandle,":Stud_Min:script_name")

onFail
errorShow("Trying to execute Sql Statment.")
endTry

endMethod
-----------------------
I keep getting an error "Invalid Field Name : dates"

I have run plenty of updates scripts on the MS SQL server, just not so many on locally saved tables.

Any help would be greatly appreciated.