<i><font color="#663300">I have a form with a command button that browses a set of records which include a general field. I can add the embedded graphic I want this way but when I go to SAVE the record, I get the following error:
Error #: 1489
Message: General fields cannot be used in the WHERE condition of an update statement. Change the WhereType property of the view.
Line #: 44
Code: ERROR lnRetVal
Method: save
Object: ins_cad_add_form
This doesn't happen if I update the table directly... Is it possible to add data to a general field via a VIEW, or is it only possible by directly accessing the TABLE???
And if So, I guess I should open the table exclusively with this special form and close it explicitly when the form is destroyed?</font></i>
Sounds like you have the view set up incorrectly. Open the view you are using, and on the Update Criteria page, set the "SQL Where Clause Includes" option to "Key Fields Only". You should do this with <b>all</b> your views, as this is the most efficient method over a network. Codebook handles the conflict checking that the other options are intended to deal with.
<font color="#cc0000"> ___/
/
__/
/
____/</font>
Ed Leafe
©2002 Ed Leafe |
