Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ADO where clause on updates
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00148222
Message ID:
00148314
Vues:
26
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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform