Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Anywhere to VFP?
Message
De
09/12/1999 05:07:12
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00300642
Message ID:
00300877
Vues:
16
>We need to convert data from an SQL Anywhere database to VFP. Can someone give us advice on how to connect to the SQL Anywhere database and start the conversion process.

You can download from sybase ISQL.exe:

OUTPUT TO filename

... [ FORMAT output_format ]
... [ ESCAPE CHARACTER character ]
... [ DELIMITED BY string ]
... [ QUOTE string [ ALL ] ]
... [ COLUMN WIDTHS (integer,...) ]

alternatively you can access from odbc (get the full odbc client installed from their cd). Create a data source in odbc panel. then from vfp:

iConnect = sqlconnect()
sqlexec(iConnect,
"select * from this_bloody_server_table","a_good_old_vfp_cursor")

ASA is a very credible and unexpensive partner to vfp, not only for a one shot download. We have a significant vfp app running asa as a back-end

good luck
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform