Why one records turned to '##########' characters

[Rayis]

I have a table with about 6000 records. During the insert/update process, one record has been transformed to a strange way:

1) all string column started to have 16 '#' characters despite of their actual size.

2) all date and numeric fields became NULL

3) bit flag turned to 0

The table itsels if working, repair function does't resolve the problem.

And I can change value in this table.

What happend and how can I prevent this situation.

Please help me.

[Rawhide]

What is your insert/update query or process?

[Rayis]

Originally posted by Rawhide
What is your insert/update query or process?

either way, data is updated through edit controls and through SQL - scripts and saved queries.

[Rawhide]

What are the queries?

[Rayis]

Originally posted by Rawhide
What are the queries?

SQL update and insert scripts to the table that have these ##### records.

[Rawhide]

I don't want you to describe them. I want you to post them.