>Thanks for answering back Eric. I verified the values and even tried replace command, but to no avail it still doesn't want to update my core table. The field are check marked for update(there is only one field to update) and also primary key is checkmarked. I do have another view in the data environment that I am performing INSERT command, could this be the problem?
Is this a double buffering problem? IOW, do you have a buffered copy of the underlying table open in the same datasession? If so, the changes from your view are being written to the buffered table, and never to the copy on disk. You can fix this by removing the buffered copy of the table, or by subsequently issuing a TABLEUPDATE on the table itself.
Erik Moore
Clientelligence