<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 color="#cc0000"> ___/
/
__/
/
____/</font>
Ed Leafe
©2000 Ed Leafe |
