Re: Dynamic SQL. Is it possible?

[peter.hamilton-scott]

Roland, thanks for the excellent narrative and whilst reading it some questions came to mind.

1. How do I know which version I have installed? I downloaded the latest of everything from the MySql site. I have Administrator 1.1.4 and Query Browser 1.1.17. Are these ok? I noticed that if I enter status in the MySql command prompt, it lists 5.0.15-nt so I think that's what you are referring to?

2. In the example above, you use @sql_text as a global user variable. Is that variable of your own choosing? What is its datatype defined as?

3. In your assignment statements you use := were I've only seen = used. I know it sounds dumb, but are they just different syntax styles for the same thing?

4. In my Query Browser 1.1.17, I can see tables and procedures, but I can't edit triggers. Instead I have to edit them outside of Query Browser and add them by file into MySql. I'm thinking that maybe triggers never made it in time for Query Browser because they are new additions so they missed the boat so to speak?

Thanks.