Hi Keith,

Thank you for you very prompt response.

After days of blindly searching elsewhere, I discovered yesterday that my venerable DESCE (Description-English) field that I've used for years was to blame. Never had a problem in FPW or VFP. Changed it to DESCENG and all worked well.

I am still wondering, though, how I could have seen the update SQL statement that caused the error. The 'See SQL' option seems to show you the 'Select', not the 'Update' portion. Any ideas ?

I appreciate the code you sent. Barring seeing what's happening in SELECT and UPDATE statements, I think I'd rather make the views in code so as to retain control over what's happening. I will go over your code and see what I can adapt to my needs.


Again, thank you for your help. It was very appreciated.

Henry