T
Thomas Mercer-Hursh
Guest
Ah, yes, Gus, I meant to mention this in my original post. Once upon a time before we had temp-tables, I had a reporting technique which would make a copy of an empty database containing some appropriate generic tables and attach to that DB before invoking the actual report body. The report body would then fill that DB as needed for the specific report, print the report based on the DB data, and return where the DB would be detached and deleted. But, one could certainly leave it around ... if that were actually a good idea. Oh, and it isn't as if I have an absolute rule against not using other technologies ... these days, that would be positively silly. But, I do think there is something significant to be said for keeping logic in one place. One of the reasons I have always been against database triggers is that it puts the application logic in more than one place.
Continue reading...
Continue reading...