Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate seems to send wrong value to server
Message
From
25/06/2008 07:31:16
 
 
To
23/06/2008 12:39:58
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
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:
01326578
Views:
15
>>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.

Hi Hilmar,

Thanks for answering.

Examining the view it seemed correctly defined and, in fact it had been working until the last build, but by deleting it and creating it again the problem went away. Now I won't know what the problem was.

Alex
Previous
Reply
Map
View

Click here to load this message in the networking platform