Except the same code, on a different but similar table, does not show the same issue. It is the TableUpdate that throws this error and I'm just trying to narrow down any possible causes.
Michael Oke, II 661-349-6221 Contents of this and all messages are intended for their designated recipient. On Aug 7, 2012, at 10:33 AM, Fred Taylor <[email protected]> wrote: > Since the square brackets are also string delimiters in VFP, does the code > that accesses SQL Server syntax use them as string delimiters? If so, it > could confuse the content of the string. > > ie: > m.somevar = [this is a [string in square brackets] would fail] > > or maybe: > m.somevar = [&othervar] > > > Fred > > > On Tue, Aug 7, 2012 at 10:07 AM, Michael Oke, II <[email protected]> wrote: > >> Strange error happening. VFP 6 application using SQL server backed. We >> are using remote views to access the data When attempting to save a record >> that has a text field with special characters in it, such as [ ] square >> brackets, we get an error: Update Conflict. Anyone have any ideas as to >> what to look at? >> >> >> Michael Oke, II >> 661-349-6221 >> >> Contents of this and all messages are intended for their designated >> recipient. [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
