LOL! I'm talking to myself! I think I know what is happening. This button opens a new form from an existing Edit form so the recrod is already open and possibly changed! Voila! a conflict when I try to save the form with the update for the General field...
How can I close that form and just give control of the record back to the underlying form??? both are modal. and the first form is very busy already -- so I'd prefer not to put the general field editing directly on the first form! Any suggestions?
Thanks!
Lynette
<i><font color="#663300"><i><font color="#663300"><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
</font></i>
Additionally, Here are all the settings on my Update Criteria Page for the View (maybe I have something else wrong?):
Only specific fields selected - keyfield, parentkey, general field, and name field
filter is set to keyfield = ?vp_keyfield
No Order, No Grouping, No Joins
Update Criteria is: table: ibldg
Send SQL Updates is checked
all fields checked, keyfield double checked
SQL Where Clause includes: Key Fields only (as noted)
Update using --- SQL Update selected (was SQL Delete then Insert)--- same error either way...
My form uses a link to the application to find the file, then opens a browse so you can double click on the general field and paste the data in as a picture (we want the info embedded) .
I'm at a loss.
Lynette</font></i>
Lynette
ltillner /AT/ yahoo .D.O.T com
©2002 Lynette Tillner |
