<i><font color="#663300"><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></i>
And quickly, before Ed goes on vacation... When I did that I get this error:
Error #: 1912
Message: Operation is invalid for a General field.
Line #: 51
Code: IF NOT (OLDVAL(lcFld) == CURVAL(lcFld))
Method: conflictcheck
Object: idatabehavior
What should I do? Punt and use the table for this form only????
Thanks!
Lynette
Lynette
ltillner AT yahoo D.OT com
©2002 Lynette Tillner |
