Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO where clause on updates
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00148222
Message ID:
00148314
Views:
25
You can't call Stored Procedures from any ODBC code. The following
also doesn't work:
 SELECT SomeStoredProc() fROM DUMMY where recno() = 1
I thought it did, but it doesn't <s>...

+++ Rick ---

>Hi Chad...
>
>Are you looking for something that limits what updates do and don't go through - similar to what we have in views???
>
>My guess is that if something like this is available - it will be exposed in the properties collection of the RecordSet object. What this collection contains and what RecordSets and Connections in general are capable of doing - is determined by the provider.
>
>As far as I can tell, we cannot do something like this:
>
>oconnection = createobject("adodb.connection")
>ocommand = createobject("adodb.command")
>oconnection.Open("testvfp")
>ocommand.activeconnection = oconnection
>ocommand.commandtext = '=dbsetprop("view1","view","wheretype",2)'
>ocommand.execute
>
>Perhaps the solution is to create a VFP COM Object that will do this work for you..
+++ Rick ---

West Wind Technologies
Maui, Hawaii

west-wind.com/
West Wind Message Board
Rick's Web Log
Markdown Monster
---
Making waves on the Web

Where do you want to surf today?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform