>The simple and obvious answer is that you need everything (the whole script) as a one command for execsript (with CRLF between each VFP command), not each command as a separate execscript since each of them is executed in its own environment and has no idea about previous execscript command.
>
>Cetin showed an example here and in MSDN forum how to invoke one long command.
>
>You may check this thread at MSDN
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1771883&SiteID=1 for the sample of executing long text.
Thanks for the info
I have checked the link. This is dedicated to an OleDb provider. My data class is generic so it will fit with several providers. See the other threads I just started in order to obtain a generic way. As is, it works. Thanks for the information of that link which demonstrates that it works. However, as this point, I need to proceed and find a way to have this working with a IDbCommand declaration instead.