It's 2005 Express...
>Hi Menachem,
>
>What is your SQL Server version and how big is the file you're going to send?
>
>If it's SQL Server 2008, I'm thinking, can you use table variable instead?
>
>E.g.
>
>text to lcSQL textmerge noshow
> declare @Tbl table (Field1 int, Field2 varchar(30))
> insert into @tbl
> values (<<>>,<<>>) -- you can use here a different way to merge if you need to pass many records (using textmerge)
> execute mySP @Tbl
>endtext
>
>
>>HI all,
>>
>>I have a desktop app and I want to send a lot of records up to SQL in one batch. I am using someone else's code and he has it written to accept XML. I have tried to cook up the XML to send it off and, although I get a succesful return, nothing is happening.
>>
>>I am using CURSORTOXML() to create the XML on the VFP side and am sending it through to the SQL procedure something like this...
>>
>>
>>*-- lcXML is a variable with the XML code in there as produced by CURSORTOXML()
>>*-- loDataLib is my class that handles functionality for communications with SQL back ends
>>*-- dbExec is a wrapper method to SQLExec. The handle and connect are all handled internally
>>*-- Syntax is dbExec(<cmd>,[<cursor name for returned data>])
>>
>>lcSQL = "EXEC p_StoredProc '" + lcXML + "'"
>>loDataLib.dbExec(lcSQL)
>>
>>
>>The command executes and SQL doesn't seem to complain but I am getting no added records to the database.
>>
>>I know I am doing something wrong... I am just not sure what. Any assistance would be appreciated.