David,

I assume you already checked this thread Re: So, I have a view to a table outside of the database.... Thread #660583 Message #660666 ?


And the same advice from Hector Correa: Re: SQL View on Free Tables Thread #619641 Message #619645

And explanation by Sergey B Re: 2.6 FoxPro Tables in a 7.0 view. Thread #612517 Message #612556

And this one Re: View, database losing free tables Thread #557275 Message #557292

BTW, no need to post multiple messages of the same problem here...

>I created a view, v_ordrfile, based upon a free table, ordrfile. I used the 'other' button in the view editor dialog box to specify the table and path. BTW, the ordrfile table is not in the same folder as my dbc.
>
>Immediately after I created the view, I issued the command 'use v_ordrfile' from the command window. The view opened up. The I did some other operations (not sure what). Then I attempted the same command, 'use v_ordrfile'. However, this time, a dialog box came up, with a list of tables in the dbc, and an 'other' button. I chose the other button, and it let me choose my free table again. Thereafter, when I issued 'use v_ordrfile', I did not get the dialog box again.
>
>It seems as if VFP was confused (or at least I am confused!) about what the path is to the free table. What property of dbgetprop()/setprop(), or cursorgetprop()/setprop() ?? can be queried/set regarding the path.
>
>?dbgetprop('v_ordrfile','view','tables') returns 'ordrfile' with no path.
>
>?dbgetprop('v_ordrfile','view','sql') returns a sql statement that has no path specified in the from clause, it is just 'from ordrfile'.
>
>?cursorgetprop('sourcename','v_ordrfile') returns 'v_ordrfile'
>
>I would think based upon the vfp help, that sourcename would have the full path to the table, but it doesn't.
>
>The vfp help for cursorgetprop says:
>
>Database C The name of the database in which the table or view is contained. If a table is a free table, contains the empty string.
>Read-Only.
>
>SourceName C Contains the long name for a SQL view or a table in a database, or the file path and table name for a free table.
>Read-Only.
>
>I am building this view in a test environment. I need to be able to change the path to the free table at runtime.
>
>TIA