...

View Full Version : Corel Paradox Scripting



bean262
07-22-2004, 03:12 PM
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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum