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;")
>