Hi folks,



Got to as a question as opposed to answering them ;*)



I generate a dynamic sql statement via code (via lookups to keep it database

driven)

the TSQL is valid, exec it in query analyser and it returns the correct data



All of my DA code is via stored process, so I use the same ADODB.cmd

generator to get an active command, then do

cmd.CommandType = adCmdText

cmd.CommandText = strTSQL



Set rs = cmd.Execute



rs has 1 field (correct) but of NULL value.



compared to the Query Analyser's numeric value.





Any ideas at all ??? as I am completely stuffed at the mo





Regards



T