Rox,
>I've recently done an exe where the dbc and dbfs were all included in the distributed exe and had no problem running a SELECT against anything within that same exe (didnt have your scenario where your crossing two different app's but hey it worked in a single exe)
Yep. works in the SAME app or exe, but not if you open the files in a different app/exe.
>So here's a WAG...
>>select * from testtable
>
>slap in a DBF() maybe?
>select * from DBF(testtable)
I think you meant:
select * from dbf("testtable")
This does avoid the error message...by activating the open dialog. Not much help really. Thanks for the WAG, but...
BTW, the function DBF() shows the path to the original file, even though it has been moved/deleted.
Any other WAG's that might prove fruitful?
Timothy D. Yeaney
MCSD, Charter Member
President, PAFOX (Potomac Area Fox User Group)
mailto:
tim@eagleeyeinc.com Vice President
Eagle Eye Publishers, Inc
Broaden Your Vision, Sharpen Your Focus