>I have data sitting in a Access database .., Just for development where I plan to upscale to SQL server.
>
>My problem is I have two tables:Table_A, Table_B
>
>I have two views View1 = Table_A
>and View2 = Join of A+B
>
>update View1 set flag = m.chrtime where lockid = "JO" and actiontime < m.thistime
>tableupdate(1)
>
>*set step on
>select View2
>requery()
>
>Now I have async processing flagged in the connection and its a local data session to the form, I used fox to create the views I didnt code them myself.
>
What do you expect with Asynchronous processing? If you need the TABLEUPDATE to wait until the changes are actually made before returning control to VFP (like you need if you will soon be querying the same data), then uncheck "asynchronous".
Off the subject, but it's also a good idea to check the return value of TABLEUPDATE to make sure that the update went well...
Erik Moore
Clientelligence