Thanks to all that replied. Mike Babcock has the answer in his _DataObj.prg
Download and have a look at this: http://mbsoftwaresolutions.com/demos/vfp/mbss_piecerate.zip Thanks Mike Happy Easter to all Rafael Copquin ----- Original Message ----- From: "Rafael Copquin" <[email protected]> To: <[email protected]> Sent: Wednesday, April 08, 2009 3:04 PM Subject: Re: vfp9 and sqlserver express > In addition and to clarify my question, I use a cursor adapter to > establish > the connection to the SQLTable. > > Then the insert would be to the CA generated from the SQL table. > > Or else, use sqlexec to insert directly into the SQL table > > Rafael Copquin > > ----- Original Message ----- > From: "Rafael Copquin" <[email protected]> > To: <[email protected]> > Sent: Wednesday, April 08, 2009 2:54 PM > Subject: vfp9 and sqlserver express > > >>I wonder whether it is possible to send an object from a scatter name >>command in VFP to a SQLServer table. >> >> IOW, in VFP I do this >> >> select curCustomers >> scatter name oCust >> >> insert into customers from name oCust >> >> Is it possible to do this but trying to insert into a SQLServer table? >> If so, could you post the code? >> >> Rafael Copquin >> >> >> --- StripMime Report -- processed MIME parts --- >> multipart/alternative >> text/plain (text body -- kept) >> text/html >> --- >> [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/200940cd22314bda9000883bc007b...@rafael ** 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.

