Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Value is not written to the the field in the table
Message
 
To
17/10/2001 09:58:44
General information
Forum:
Visual FoxPro
Category:
CodeMine
Miscellaneous
Thread ID:
00569542
Message ID:
00569716
Views:
33
>VFP 6
>CodeMine 6.1.19
>
>
>Let me first state this. Before adding this field everything was allright.
>
>I added a field (CheckSum) so that the checksum for the field can be calculated.
>
>I use a view in the Data Environment of that form.
>
>Updateable is set for that field in the view.
>
>
>
>I added that code in BeforeUpdate method of cmDataManager of that form
>
>m.oAuth = CreateObject("cmAuthentication")
>select lv_NameOfTheView
>replace CheckSum with m.oAuth.AuthenticateRecord("CheckSumString","CheckSum")
>return .t.
>
>I put a set step on before the return .t. and looked at the content of the view. All the data is there with the checksum.
>
>The weird thing is that only the checksum is not written to the table.
>
>
>I know that modifying a table can cause problem with a view that was associated to that table. So I created the prg for that view. Deleted the view and recreated the view from the prg.
>
>That step did'nt help at all ;-(
>
>
>Can you figure out what's wrong?

Hi Denis,

1. Are you sure that the CheckSum field is updatable?
2. You SELECT lv_NameOfTheViewTry, but try just in case:

REPLACE lv_NameOfTheView.CheckSum with m.oAuth.AuthenticateRecord("CheckSumString","CheckSum") IN lv_NameOfTheView
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform