Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Opening database via ODBC
Message
De
28/03/2006 12:03:36
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Opening database via ODBC
Divers
Thread ID:
01108409
Message ID:
01108409
Vues:
53
Hi all!
I'm trying to connect a DBISAM database via ODBC. Connection runs well I gess, I can list tales in database, but how can I read/browse a table?
Any help will be great.
Thank's in advance,
NPedro



****** SAMPLE CODE *******
nHandle = Sqlstringconnect("Driver={DBISAM 4 ODBC Driver};ConnectionType=Local; CatalogName=c:\datapath\data;TablePassword=323533")

*!* nHandle : returns positive number: OK

nTables = SQLTables(nHandle, 'TABLE', 'mycursor' )
Select mycursor
Browse

*!* browses tables names... inside database: OK

nResult = SQLExec(nHandle, 'use tablexxx')

*!* returns negative number: ERROR!!!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform