Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Hello folks,
>
>Scenario:
>
>A VFP8 Win32 executable that reads and updates Access mdb file.
>
>I have the access mdb structure (test file) and have to make VFP exe to read ad write it. This should be done so that I make the VFP exe, send it to my client, nothing else just the exe file (wrapped with ISX for runtime files) and he/she installs it, launch it and this app reads and writes his/her access mdb file.
>
>What would be the preferred way to open/read/update mdb? I would like to use VFP CA but have use it only with VFP natives and haven't see any example how to use CA with above situation.
>
>TIA
>
>AT
SQL Passthrough is a good technique to deal with Access data
use
SQLSTRINGCONNECT() to connect to the data
SQLEXEC() to execute queries and updates against the mdb database
SQLDISCONNECT() then closes the connection to the mdb database
Précédent
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