Another thing.
Substituting the line
cStmt = cStmt + ', Field' + Transform(i) + ' Text Not Null'
With
cStmt = cStmt + ', Field' + Transform(i) + ' Text Null'
And
Replace ('Field' + Transform(i)) With Transform(i) In Temp
With
Replace ('Field' + Transform(i)) With NULL In Temp
the server receive the statement:
exec sp_executesql N'Insert Into #Temp(Field1) Values (@P1 )', N'@P1 char(8000)', NULL
instead of
Insert Into #Temp(Field1) Values ('' )
and finally the error do not occurs .... but i'havent the answers for the question in the preceding message ..... this fake - error drive me crazy ....
Thanx in advance!
bye, Emanuele!
In the beginning the Universe was created.
This has made a lot of people very angry and been widely regarded as a bad move.