Painful LLBL output to readable data.

I am working on this client project when the LLBL output is giant with query being 1100 + characters long with atleast 10 parameters.  Its very painful to read this query and hurts when you have to run this in SQL to see the output.  I put in about a hour to convert this 1100 long query into a readable format with /r/n s and replaced the parameters with specified value.

Take a look at the screenshot.

Link to LLBL Forum where the code is posted  – http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=20564&StartAtMessage=0&#115911

Here is the code and the executable


Advertisements
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: