NCS Logo - Click for home page Northstar Developer Center
Platforms
All Platforms
.NET Framework (1.x - 4.x)
Active Server Pages
ASP.NET
C#
SQL Server
VB.NET
Visual Basic

Keywords
.NET Data Types
.NET E-mail
.NET Events
.NET Functions
.NET Object Programming
.NET System.Configuration
.NET System.Diagnostics
.NET System.IO
.NET System.Net
.NET System.Net.Sockets
Active Data Objects
ASP Architecture
ASP Black Belt
ASP Built-in Functions
ASP Built-in Objects
ASP Debugging
ASP Performance
ASP Security
ASP Syntax
ASP.NET Authentication
ASP.NET Controls
ASP.NET Data Access
ASP.NET Features
ASP.NET Master Pages
ASP.NET Page Events
ASP.NET Security
ASP.NET ViewState
Atom
Certifications
COM, DCOM, COM+
Data Access
E-Mail
Errors
Exporting Data
HTML Tips
IIS
Object-Oriented Programming
RSS
SQL
Uncategorized ASP Tips
VB API Programming
VB Forms
VB Syntax
XML

Book Support
Visual Basic 6 Bible
ASP Bible
ASP Weekend Crash Course
ASP.NET At Work
Creating Web Services

Procedure Too Large Message

Written by Eric Smith, Northstar Computer Systems LLC

Well, this is a new one for me. A user said that he had a procedure with approximately 4000 ListBox AddItem lines in it and was getting an error from Visual Basic about the procedure being too long.

I personally didn't remember VB having a limit of the number of lines in a procedure, but this guy found it. The first thing I would suggest is that the data (entered manually) be put into a database. The developer could then query the database and return as many rows as necessary for the application to work.

The point of this is that if you're manually entering more than a few data values, that data should be put in some sort of permanent storage mechanism OUTSIDE of the application. This includes files, databases, XML files, or whatever you want -- just don't put it directly in the application.

Keywords: [ Errors ]

Publication Date: 10/1/2000