<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 |