Need Advice On How To Edit/Update FoxPro Tables From VB Form 1

[drosenkranz]

Most of my VB work has been using Access and Native Jet. I'm trying to edit and update FoxPro tables from a VB application. I created an ODBC connection that allows me to view the FoxPro table but I can't save my changes back to it. How do I do this? Any advice would be greatly appreciated.
The 2nd mouse gets the cheese.

 

[Ologhai]

Hi

I use Foxpro *.dbf table with DAO in my VB program.

this is a part of codeL:

dim fdyn As Database
dim tbl As Table

Set fdyn = OpenDatabase(Trim(DynacomPath), False,
False, "FOXPRO 2.5;&quot
Fich_Rech = "empfil"
Set tbl = fdyn.OpenRecordset(Fich_Rech)
tbl.Index = "emplcode"
etc ...

I hope this will help you
_____________________________
Hugues Gauthier P.A,DEC
Programmeur Analyste
Progitech GS Inc.

http://www.progitech.com/

hugues.gauthier@progitech.com
hugues_gauthier@hotmail.com
Tel. : (418) 698-4383 #19
Fax.: (418) 698-8633
---------------------
ICQ: 2151800

 

[drosenkranz]

Could you elaborate on the line

Set fdyn = OpenDatabase(Trim(DynacomPath), False, False, "FOXPRO 2.5;&quot

Is DynacomPath the file name and path?

Is "FOXPRO 2.5;" the DSN ?

Thanks


The 2nd mouse gets the cheese.

 

[Ologhai]

I work with Dynacom windows files.

Dynacom is a comptable software built in foxpro.
*.dbf

you have to open a directory, not a file.

set fdyn = OpenDatabase("c:\dynawin\data01",
False,False, "FOXPRO 2.5;&quot

yes "FOXPRO 2.5;" is the DSN

i use Microsoft DAO 2.5/3.5 compatibility library

good luck.

_____________________________
Hugues Gauthier P.A,DEC
Programmeur Analyste
Progitech GS Inc.

http://www.progitech.com/

hugues.gauthier@progitech.com
hugues_gauthier@hotmail.com
Tel. : (418) 698-4383 #19
Fax.: (418) 698-8633
---------------------
ICQ: 2151800

 

[drosenkranz]

Hey TeteLouch,

How (where) can I get a copy of Dynacom software???

Thanks my friend.
The 2nd mouse gets the cheese.

 

[Ologhai]

i think it's imposible to find this software now
Dynacom release his new version. and they use Access 2000
and flush *.dbf, i think is a good move

i can send you dbf files that i work with

gemme your email !

_____________________________
Hugues Gauthier P.A,DEC
Programmeur Analyste
Progitech GS Inc.

http://www.progitech.com/

hugues.gauthier@progitech.com
hugues_gauthier@hotmail.com
Tel. : (418) 698-4383 #19
Fax.: (418) 698-8633
---------------------
ICQ: 2151800