Nadya,
Thanks. I had done a search, and had seen some of these, but not all, and not the ones that were most relevant. Anyway, I see the issue now, and all is well.
Also, I got your message about the multiple posts too.. Sorry to 'clog up the UT', with duplicates. I will figure out the proper way to send a private message next time!
>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