workaround to MySQL's limitations

[bxgirl]

Working with Mysql 4 and VB6. the following features are not supported in mySQL 4

subqueries
stored procedures

Can anyone recommend great reading for workarounds for most of the MySQL's limitations.

 

[cyoung]

Upgrade to Mysql 5?

As for the subqueries, use a temp table. As to stored procedures, write a client side equiv, or a command line event on the server. It depends on what you are trying to acheive as to the type of answer you will get.

 

[bxgirl]

Upgrading is in future plans but right now I need to work with what I've got.

you wrote: write a client side equiv...you mean formulating a sql command and execute it with conn.Execute or using recordsets.

I'll need to look into command line event on the server.

For an example of what I need to do check out this thread

http://www.tek-tips.com/viewthread.cfm?qid=1162626&page=1

 

[guelphdad]

are you using mysql 4.0 or 4.1? 4.1 does support subqueries. Also note that subqueries are not necessary as all queries using subqueries can be re-written as joins.

 

[bxgirl]

I believe is ver 4. How can I check to make sure.?

 

[guelphdad]

type select version(); at your mysql prompt.

 

[bxgirl]

version 4.0.13

 

[cyoung]

I looked at the example you provided, and it really is a poor design for a customer tracking system.

Instead of spending the time to fix the current system, invest the time in creating a new system.

The mutiple tables that you are using are not a good design, and as another person pointed out, they will cause you grief as the system tables increase, or if you have muplitple packages to a single person.

To get the reporting you need, you would not need sub-queries in a properly desinged database, and any future mods would be easier to implement.

 

[bxgirl]

I agree... it's poor design.

Definitely needs redesign.