Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL Pass thru How select different database?
Hi,
I've connected to a single datasource that has multiple databases.
After initial connection I get info and issued connect to new database.
But VFP refuses to let go of the original database. I'm using
SQL Pass through. Is it possible to do this? I tried issuing a
CLOSE DATABASE after getting data from first database then creating
a new database thing it would release the info but no go.
My question is how do I switch between two databases that have one
datasource? Thanks
create database ctes && Temp on the fly cursor
create connection allt(l_sqladdr) datasource allt(l_sqlsourc) USERID allt(l_sqlid) PASSWORD allt(l_sqlpass) database allt(l_sqldata)
&& Connect and get file handel
temp11 = sqlconnect(allt(l_sqlsourc),allt(l_sqlid),allt(l_sqlpass))
lnresult = sqlexec(temp11,"SELECT * FROM scomp", "STSYS")
=SQLDISCONNECT(0)
CLOSE DATABASES
ERASE ctes.dbc
ERASE ctes.dct
ERASE ctes.dcx
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement