Cetin,

Hi. How are you? I posted a thread to 'ALL',but I am sending you a direct message here as well, in the hope that you can help me. I don't mean to impose, in the event that you are very busy - so do not feel obligated to reply. In the past, you have been very helpful to me, and also, I saw some other threads where it was obvious that your knowledge in this area was excellent.

Anyway my problem is as follows:


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