Runs Crosstab queries on mySQL (Server Side)
Author:Gert-Jan van der Kamp
Version Compatibility: Visual Basic 6, Visual Basic 5
This is a demo app around a function that converts the TRANSFORM syntax to a normal query mySQL can understand. (based on the article by Giuseppe Maxia) Just click connect, paste your TRANSFORM statement and run it. The function can easily be reused in your own app. Enjoy!
Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.