MySQL
    Trevor DeVore 
    lists at mangomultimedia.com
       
    Mon Nov 27 12:08:25 EST 2006
    
    
  
On Nov 27, 2006, at 8:54 AM, Mark Schonewille wrote:
> Getting records is not the problem. I want to find out which  
> databases and tables are available. Should I use revQueryDatabase  
> for that? Can you give an example?
Though you aren't actually fetching records with a SELECT query, you  
are fetching records since MySQL is returning records containing the  
database names.  Because of this, you need to use a RevDB call that  
will return records.  You would iterate through the cursor just like  
you were if you were returning records.  John's suggestion of using  
revDataFromQuery would probably be easiest for what you are doing  
though since you don't have to fuss with a db cursor.
-- 
Trevor DeVore
Blue Mango Learning Systems - www.bluemangolearning.com
trevor at bluemangolearning.com
    
    
More information about the use-livecode
mailing list