Hi Y'all,

I have a local view that when it is updated, it does the odd "wierd" thing to the table - much as if I had hand-written an "update" statement that had some logic error in it.

Is there any way I can grab the actual SQL statement that VFP is using to do the table update? This is a local view using VFP as the data engine so it's not like I am using ODBC or SQL server where I can capture what is being sent to the back end. I looked around for a SYS() command that might give this to me but I could not find anything.

Albert Gostick