Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Unaccountable Fake-Error from Sql Server
Message
De
11/06/2004 05:45:37
Emanuele Bonin
EB Soluzioni Informatiche
Tezze S/B, Italie
 
 
À
11/06/2004 05:05:03
Emanuele Bonin
EB Soluzioni Informatiche
Tezze S/B, Italie
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00912576
Message ID:
00912597
Vues:
11
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform