Ed Leafe wrote:
> On Aug 9, 2007, at 8:51 PM, MB Software Solutions wrote:
>
>
>> Are we talking about local views (VFP backend), remote views (non-VFP
>> backend), or just the concept of views in general? Charlie Coleman
>> uses
>> a concept where he does SPT to get cursors and then makes the updates
>> himself (via code) instead of dealing with views. I'm doing that
>> somewhat anymore too with non-VFP backends (in my case, MySQL).
>>
>
> This is the best way to deal with remote data, and Paul McNett's
> MakeUpdatable program (available on my download page) is invaluable
> in dealing with the Fox requirements for updatable cursors.
>
>
Yes, I had used that a lot, and in that VFP9/MySQL source I posted in
your forum, I believe I utilize Paul's routine. However, for some odd
reason, I've encountered a scenario lately where the TABLEUPDATE would
fail, and regardless of everything I tried, I couldn't get it to work,
nor could I get VFP to give me any reason as to why it failed. The 4th
parm ("gaErrorArray") didn't pick up any messages from MySQL, and
AERROR(laError) was equally useless. Wish I could've solved that one!
--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
"Work smarter, not harder, with MBSS custom software solutions!"
_______________________________________________
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.
