By host on Saturday, March 25, 2006 5:27:42 PM

Today I released the final version of SQLGridSelectedView V3.4e.  This is the non-beta release for the module. 

It seems I can't leave it alone. I had planned to just release this version with the one or two little issues corrected, but instead I had to add a bit more. 

Although I had not mentioned it, the beta's had some improved SQL error handling.  Previous versions would just dump the ASP.NET stack dump with all the detail including the SQL command being exeuted.  My original rational was I want to see where I screwed up as most of the SQL error were based on the program's attempts to build the SQL command.  Now that I seem to have that under control, I really didn't need to display all that extra stuff.  Also, I really didn't think about it until I got a comment from a user asking that I curb the detail displayed.  So, I have been cleaning up the error handling in V3.4

Two last pieces were required. The first, was an option to display the SQL command whenever a SQL error occured.  This...

Read More »

By host on Saturday, March 18, 2006 10:41:47 PM

I got a feature request for SQLGridSelectedView to allow multi-answers so the user could use the T-SQL "In" feature.  Specifically, the user, Paul Bennett, wanted a way to allow a copy and paste from Excel to be handled.

He wanted to pass in a column of Excel data containing Computername so he could do a Select like:

Select * from Requests where Computername in ( [Search:Text] )

While this would work for a single entry, I agreed that this is a worthwhile feature, so I added a Multi-Answer option to the TextSearch filters to allow the end-user to enter multiple entries.  Each Entry must be on a separate line.  If the entry ends with a comma (",") I will remove it.  Blank lines will be ignored.

So the above example would expand to something like:

Select * from Requests where Computername in ( 'COMP1', 'COMP2' )

Each entry is enclosed in single quotes and separated by commas. 



I have also added a similar feature to the Filter selections.  When the Multi-Select...

Read More »

By host on Sunday, March 12, 2006 2:04:55 PM

Now that I have returned to Canada, I started work on completing the beta version of SQLGridSelectedView.  Today I released the latest beta version 3.4c. 

This version continues the work in two specific areas -  Localization and date selection.  I had many request for a calendar feature on the date selection so I finally honoured that request.  However, I use the time feature in several on my installations, but others found this to be overkill so I now allow the addition of the time to be a feature.

When I initially implemented custom column formating, the ability to sort these columns was lost.  I have added that feature so you can now sort the formated columns

Localization is a tricky issues, especially when you are working in single language all the time.  Living in Canada where there are two official languages, all application must be able to handle either French or English, so I am at least aware that there is a need.  I have chosen not to localize the Edit Settings for SQLGridSelectedView...

Read More »

By host on Monday, March 06, 2006 7:40:37 PM

In the spirit of Bob Vila .. I am almost "home again" ... I will be returning home later this week.

Read More »