tg - makes sense

I wish SeanK would find the time to leave that "write a query" in VB world and enter the land of SPROCS...

I could never imagine writing a string-concatenated mess of textbox's and query literals to get a recordset anymore.

One of my latest requests from a customer was to allow a query to be run in our app so the user could save it to a text file for import into EXCEL. I'm thinking this is VB coding - this is where to save a file - this is all kinds of non-standard, non-windows training...

After about 5 minutes I realized we needed to build a VIEW - make the VIEW realize the USERNAME of the person connected - so that only kids from their building were visible - even add other layers of SQL-side role security...

Then build an ODC file so that they could use the IMPORT option from EXCEL and make there own spreadsheets - no need to visit my app for that.

Now the spreadsheet is live - they can add columns - and still refresh with new students whenever they want...

When we do financial displays in flexgrids - we do it all in SPROCS - and we do all the totalling with UNION's and fancy order by's. We never write any VB code anymore - it's all about putting queries into SPROCS...

I think I might need a few days off