Runs Crosstab queries on mySQL (Server Side)

Category:
Database
Type:
Applications
Difficulty:
Advanced
Author:
Gert-Jan van der Kamp

Version Compatibility: Visual Basic 6, Visual Basic 5

More information:
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.

Download crosstab.zip