Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
C# 2005 updating VFP data
Message
From
09/10/2006 15:54:59
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01160448
Message ID:
01160693
Views:
7
>Thanks a lot, it was indeed a trigger that called a SP which was the culprit.
>
>Do I need to SQLize all the code in the SP in order for this to work given that the trigger code works fine if you update VFP data using VFP?

No you don't need to but check VFP help for a list of commands/functions supported/unsupported by VFPOLEDB driver. IMHO a good designed DB should never have unsupported code in its SPs. VFPOLEDB supported set is much higher for SP than it's for nonSP code.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform