I have the following code

SQLEXEC(lnAccess, "UPDATE mytable SET mytable.name = 'Test Name' WHERE (mytable.filename = tmpdata.filename)","Mytable")


I have a foxpro table tmpdata which was created by importing
data from an access table mytable. I change some values and
want to write back to the access table. But nothing happens.

The access table

Filename Text 50

Foxpro table

Filename Char 50


Anyone any ideas?