June 2, 1999

<img width="300" height="200" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" class="elementor-animation-grow attachment-full size-full wp-image-23374 ewww_webp" alt="" data-src-img="https://www.devx.com/wp-content/uploads/2022/02/thumbnail.jpg" data-src-webp="https://www.devx.com/wp-content/uploads/2022/02/thumbnail.jpg.webp" data-eio="j" /><noscript><img width="300" height="200" src="https://www.devx.com/wp-content/uploads/2022/02/thumbnail.jpg" class="elementor-animation-grow attachment-full size-full wp-image-23374" alt="" />

Scrub Out Unused Constants

June 2, 1999

Low-level parsing in VB doesn’t come up every day. This routine demonstrates how to search a VB module for dead module-level constants with only a few lines of code. Reading

<img width="300" height="200" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" class="elementor-animation-grow attachment-full size-full wp-image-23374 ewww_webp" alt="" data-src-img="https://www.devx.com/wp-content/uploads/2022/02/thumbnail.jpg" data-src-webp="https://www.devx.com/wp-content/uploads/2022/02/thumbnail.jpg.webp" data-eio="j" /><noscript><img width="300" height="200" src="https://www.devx.com/wp-content/uploads/2022/02/thumbnail.jpg" class="elementor-animation-grow attachment-full size-full wp-image-23374" alt="" />

Identities and Triggers—A Lethal Mix

June 2, 1999

he identity property is a useful tool in designing databases. However, you can encounter serious problems with using it when combined with triggers. This problem was brought to my attention

<img width="300" height="200" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" class="elementor-animation-grow attachment-full size-full wp-image-23374 ewww_webp" alt="" data-src-img="https://www.devx.com/wp-content/uploads/2022/02/thumbnail.jpg" data-src-webp="https://www.devx.com/wp-content/uploads/2022/02/thumbnail.jpg.webp" data-eio="j" /><noscript><img width="300" height="200" src="https://www.devx.com/wp-content/uploads/2022/02/thumbnail.jpg" class="elementor-animation-grow attachment-full size-full wp-image-23374" alt="" />

Got Data? Send It to Your Users as an Excel Spreadsheet from Your ASP Page

June 2, 1999

f you are using ASP pages to display data?usually data from a database in a report format?it is usually beneficial to send this data as an Excel Spreadsheet that your