>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?


Hi,

Change the update statement to

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

Your original statement will look for the "tmpdata" table in database instead of in Fox.

:) Wilfred