Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Value is not written to the the field in the table
Message
From
17/10/2001 14:25:04
 
General information
Forum:
Visual FoxPro
Category:
CodeMine
Miscellaneous
Thread ID:
00569542
Message ID:
00569809
Views:
20
>>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

Yes it's really updatable. Your replace did'nt help on the functionality but it sure help me to make my code look prettier ;-)
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform