main logo
Subject: Re: DBGETPROP on local views
Author: Richard Canning
Posted: 2000/10/20 08:14:24
 
View Entire Thread
New Search


<I><FONT COLOR="#663300"><I><FONT COLOR="#663300">I'm not sure if I'm having a FoxPro or Codebook problem here. For some reason I'm unable to access any of the properties of a local view using the DBGETPROP() method.
Say my view field is "v_ModifyTransactions.cid"
I keep getting the VFP error which says "Cannot find v_ModifyTransactions.cid in the database".
The code breaks at the following line...
lcDisplayText = DBGETPROP( "v_ModifyTransactions.cid", "View", "Comment" )</FONT></I>

When you get to that line, what is the value of DBC()? What if you add the line <code>OPEN DATABASE [database with the view]</code> before the DBGETPROP() call?
</FONT></I>

The DBC() function returns the correct path to the database and adding Open Database to the database with the view did not change anything. I still get the error. In addition, when I break the code and check the datasession, I can see the view is selected and I am able to access the fields from the command window.
Richard Canning
Atlantic DataSystems Inc.
St. John's, NF. Canada
 
©2000 Richard Canning
<-- Prior Message New Search Next Message -->