Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate seems to send wrong value to server
Message
From
23/06/2008 12:39:58
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
23/06/2008 12:18:29
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01326127
Message ID:
01326139
Views:
14
>A remote view has primary key consisting of three fields. There is data in the buffer. One of the key fields comes from a combobox.
>The framework (Codemine) issues TABLEUPDATE(0,.F.,.F.,'ViewName') and there is an error because the keyfield that is in the combobox apparently was sent to the server as NULL, which it is not. Record is being added.
>
>Does anybody have any idea what may be happening?

It is possible that the PK is not correctly defined. In this case, the wrong records may be updated - or more than one record instead of one.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform