Thank you both, Tracy and Ted. I'll read about passign XML Rafael
El 27/06/2011 11:16, Tracy Pearson escribió: > Rafael Copquin wrote on 2011-06-27: >> Is it possible to pass a VFP 9 object as a parameter to a SQL Server >> stored procedure? >> >> The idea is something like this: >> >> select mycursor >> scatter name oMyCursor >> >> cCmd = [exec sp_mysp oMyCursor] >> >> SQLExec(nHandle,cCmd) >> >> and get the SQL Server SP process all fields from the VFP cursor passed >> inside the object thus generated? >> >> If so, how would the SP look like ? >> >> Rafael Copquin >> > Rafael, > > You might want to look at passing an XML or CSV string. I don't use SQL back > ends enough to know if it's possible to send an object. I do recall any > attempt to send a VFP object to a COM process failed catastrophically. > > Tracy Pearson > PowerChurch Software > > [excessive quoting removed by server] _______________________________________________ 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.
