Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Converting MDB to DBF
Message
De
22/06/2005 09:23:45
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Converting MDB to DBF
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows '98
Network:
Windows 98
Database:
Visual FoxPro
Divers
Thread ID:
01025422
Message ID:
01025422
Vues:
60
Dear Experts

To convert Access MDB to vfp DBF I use following codes
lcmdb=("c:\HJSDB.mdb")
Store SQLSTRINGCONNECT(;
	'DBQ='+lcmdb+';'+;
	'Driver={Microsoft Access Driver (*.mdb)}');
	TO gnConnHandle

If gnConnHandle <= 0
	= MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
	Return
Else
Endif

=SQLEXEC(gnConnHandle,"select * from lcmdb;","myCURSOR")

Select myCURSOR
Copy TO C:\PHONE.DBF
But it creates following error message
Alias "MYCURSOR" is not found
and debugger stops on second last line

Select myCURSOR

What is wrong? Please modify or suggest another codes for me

Thanks in advance
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform