On Mon, Jun 27, 2011 at 9:48 AM, Rafael Copquin
<[email protected]> wrote:

> Is it possible to pass a VFP 9 object as a parameter to a SQL Server
> stored procedure?

This is FoxPro. Everything is possible.

Is it wise? No.

You could, in theory, construct a DCOM (Distributed COM) object and
matching server on the SQL Server side to receive an object and
deconstruct it. I just don't see any benefit to it, though, unless
there's more to your problem than the question you posed.

Objects are for encapsulating behavior, and it doesn't seem you're not
asking to pass behavior here, you're passing data.

There are a lot better ways to marshall data to a remote database
server. As Tracy suggests, XML or CSV might be more appropriate.



-- 
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

_______________________________________________
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.

Reply via email to