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;")
>>
Christian Isberner
Software Consultant