Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Too many lines makes it crash
Message
 
 
À
22/09/2010 00:16:35
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01482260
Message ID:
01482285
Vues:
63
>I have this very long SQL command which is wrapped into 336 lines. While finishing it, Visual Studio starts crashing as soon as I try to add more lines. Is this a limit?

How exactly you're constructing it? Are you using StringBuilder ?

One alternative will be to use View (on inline table valued function) and another to use stored procedure.

Also in C# you can easily write long block of code with
string LongString = @"This is very long SQL
                                    statement
                                    it may spawn
                                    many lines";
Unfortunately, I don't think there is VB.NET analogue for the same.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform