>I need to open a table that is contained in another .dbc. I thought the following code would work, but it doesn't.
>
>======================================
>open database c:\app1\data\app1.dbc
>open database c:\app2\data\app2.dbc
>
>set path to c:\app1\data, c:\app2\data
>
>use app1!file1a in 0 alias file1a
>use app2!file2a in 0 alias file2a
>======================================
>
>Isn't this the way you refer to tables in another dbc?
>
>Thanks,
>
>Harry
That looks OK to me (do you get an error message, or what?), but you might also try to give the path to the DBF:
Path1 = "c:\app1\data\"
Path2 = "c:\app2\data\"
use (Path1) + file1a in 0 alias file1a
...
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)