Check if you don't happen to have fields with reserved names. For instance, once I had a field called "Value", which caused me hard-to-debug errors.
Hilmar.
>I'm trying to modify a remote view generated using an ODBC driver called "LinkBook." This driver allows access to QuickBooks tables.
>
>I can create my remote views and then browse the results. However, when I try to modify the view, as soon as I click on the modify button, I get a syntax error without any clue as to what the error is or where it is.
>
>Does anyone have a clue as to where to start hunting this one down?
>
>BTW, the LinkBook driver is seemingly a work in progress as far as VFP is concerned although the vendor seems to have it working well in Access. The vendor support has been absolutely fabulous with other problems encountered.
>
>Thanks in advance.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)