Now you could try

SQLEXEC(returnValue,"Use databasename")

If you then say

SQLEXEC(returnValue,"SHOW TABLES")
BROWSE

You should see the tables of the databasename you switched to.

>I use:
>
>

>STORE SQLCONNECT(_SCREEN.zSqlDsn, _SCREEN.zSqlId, _SCREEN.zSqlPword) TO returnValue
>

>
>where:
>(_SCREEN.zSqlDsn = datasource name
>
>since the format is:
>
>

>SQLConnect(cDataSourcename, cUserID, cPassword)
>

>
>I'm not sure how to insert the database name.
>
>please advise
>thanks for the help
>
>regards,
>
>Jerry
>
>
>
>>>I'm using MySQL database.
>>>each time I want to switch to another database I have to go through MySQL ODBC.
>>>is that possible to change the database from inside VFP?
>>>
>>>regards,
>>>
>>>Jerry
>>
>>Once you have a connection that you created with SQLSTRINGCONNECT() you can switch database:
>>

>>SQLEXEC(nConnectionHandle,"USE MyDatabase;")
>>