Thursday, May 29, 2008

Unsolved problem: unidentified values in record causing duplicate view in dbgrid after post

Certain records, whether modified or created as new record in a same or different table with the same values causes duplicate or double records in dbgrid view. A refresh on the dataset removes the duplicate record. Also, I experienced the same problem on a mastersource with a float datatype masterfield opon post of a value with decimal. This causes certain anomalies or errors on program. Again, a refresh statement solves the problem.

But what causes this problem? I never encountered this simple stupidity on other databases except MSSQL.

No comments: