Information générale
Forum:
Microsoft SQL Server
Titre:
XML generating NULL values
I have a SP that uses the xml_prepare function to create a table of an xml file passed to it. I have used this in the past but now when I try to use the same logic I get a table of NULL values. The VFP coding is as follows:
Select DISTINCT STRTRAN(ndc,'-','') as ndc From er3 Into Cursor ndctemp readwrite -- this creates the needed cursor
=contengine(sdate,edate,"ndcusage")
in the function I have this code:
ndcnum = ''
Select ndctemp
If Reccount('ndctemp')>0
=Cursortoxml("ndctemp","ndcnum",2)
Else
x=Messagebox("No saletypes were detected to send to SQL server. Please verify.",16,"Data validation.")
Return
Endif
sdate=Dtos(date1)
edate=Dtos(date2)
hconn=SQLConnect("pbisqlmemsales")
lcsql="exec contract_engine ?ndcnum,?sdate,?edate"
lnResult=SQLEXEC(hconn,lcsql,"&cndccursorname")
In the sp I have this code:
ALTER procedure contract_engine ( @ndcnum text,
@sdate datetime,
@edate datetime)
as
declare @iDoc int
execute sp_xml_preparedocument @iDoc output, @ndcnum
SELECT *
INTO #ndcnums
FROM OPENXML ( @idoc , 'VFPData/ndctemp')
WITH ( ndcnum char(11) )
select * from #ndcnums
When I pass a cursor of eight numbers to this procedure (the whole procedure is much longer but it is messing up at this first part) I recieve a table with 8 records that have NULL for values. What am I missing here?!?
Thanks in advance
Kelly
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement