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
[EMAIL PROTECTED]


_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to