>>>Yeah, odd question I know,but we've got a FPW system that needs to access VFP 3 tables.
>>>
>>>No, we can't bring the FPW system into VFP (no matter how MUCH I really want to), and I really REALLY don't want to convert the vfp file into a fox 2.x table.
>>>
>>>Any ideas??
>>>
>>>Any suggestions???
>>
>>I don't have 3.0 loaded but it works with 5.0.
>>Jeff
>
>I used Free tables not sure for dbc.
Here is what I Did.
Set up system odbc drive for vfp, free tables pointing to correct dir.
SET LIBRARY TO FPSQL ADDITIVE
nhandle=dbconnect('odbcname','','','')
sqlconn="SELECT * FROM dbfname"
ck=dbexec(nhandle,"&sqlconn","yourcursorname")
HTH Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com