If you are using VFP as a back end could you not just use SQL passthru commands to return VFP cursors rather than ADO record sets. Doing so would enable you to use all the VFP cursor power to manipulate the returned data plus you could also return function results such as datetime(). Are you committed to ADO for a specific business reason?
Glenn
>Thanks Glen, Hilmar
>
>Glen i need client running remotly on the network where VFP database is located and am not sure that your solution will work but i learned that VFP OLE DB provider can support Stored procedure which will sort out my problem.
>Except i don't know how to call stored procedure through code
>
>I came so far with this :
>
>loConnection = CREATEOBJECT('ADODB.Connection')
>WITH loConnection
> .Provider = "VFPOLEDB.1" && "sqloledb"
> .CursorLocation = adUseClient && 3
> .OPEN("DSN=WGSMS")
>ENDWITH
>
>loRecSet = CREATEOBJECT('ADODB.Recordset')
>lcQuery = "execute get_time"
>loRecSet.OPEN(lcQuery ,loConnection)
>
>lcQuery = "CALL get_time" also doesn't work.
>
>My stored procedure will be simple
>
>FUNCTION get_time
>
>return datetime()
>
>If i can call SP via OLEDB that would sort out my problems.
>
>Any ideas.
>
>Thanks
>
>Dejan
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement