MySQL

[Trevor DeVore]

On Nov 27, 2006, at 8:12 AM, Mark Schonewille wrote:

> Hi Chris,
>
> Sure, I have read the documentation. Once a database has been  
> created, I can modify it. That's not the problem. I would like to  
> do something like this (in a button):
>
> on mouseUp
>   revExecuteSQL 1,"SHOW DATABASES;"
>   put the result
> end mouseUp
>
> and would like to get a list of databases returned, but the result  
> is empty. The used parameters for revExecuteSQL are not really  
> logical of course, since I provide a database ID while the SQL  
> statement is typically executed before opening a database. Any ideas?

revExecuteSQL won't return any records (which you need to do in this  
case).

You want to use revQueryDatabase.

-- 
Trevor DeVore
Blue Mango Learning Systems - www.bluemangolearning.com
trevor at bluemangolearning.com