<I><FONT COLOR="#663300"><i><font color="#663300">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.</font></i>
<b><font size="+1">Doh!!</font></b> I don't know why I didn't see this earlier!
Here's your command: <code>DBGETPROP( "v_ModifyTransactions.cid", "View", "Comment" )</code>. And here's your error: <i>"Cannot find v_ModifyTransactions.cid in the database"</i>.
Note that in your second parameter, you are specifying "View", but the value of your first parameter is a <i>field name</i>. The error message is telling you that it can't find a <i>View</i> named 'v_ModifyTransactions.cid', which is correct, since the view is named 'v_ModifyTransactions'.
If you want the Comment for the view, drop the '.cid' portion of the statement. If you want the comment for the cID field in that view, change the second parameter to "Field".</FONT></I>
Ed,
I tried changing the second parameter to "Field" as you suggested, but now I get the FoxPro error, "Function argument value, type, or count is invalid". The error breaks at this line...
lcValue = DBGETPROP( "v_ModifyTransactions.cid", "FIELD", "COMMENT" )
Any ideas?
Regards,
Richard Canning
Atlantic DataSystems Inc.
St. John's, NF. Canada
©2000 Richard Canning |
