Heres a real puzzle…

I have a column in a table called Tree (variously renamed Tree2, XTree etc.). It is in position 61. It is impossible to change any data in position 61 in any row in this table - either through a form (database associated control) with a write event or through a Write_Row call. Other columns get updated with both methods mentioned so I know I am using the correct syntax.

Eg:

rec=XLATE('PTE_COURSE', 1, '', 'X')

rec=Test"

rec=Another Test"

Write_Row('PTE_COURSE', 1, rec, 0)

IF Get_Status(ErrCodes) THEN DEBUG

Field 1 gets updated, but not field 61.

If I change rec to rec it works perfectly.

ErrCodes returns SSP615 @FM 11

SSP615 means "Row written OK"

If I'm looking in the right place, the 11 means "system error" (FSERRORS_0)

The implications for this are pretty major as it is also happening on several other tables as well. Does anyone have any clue as to why or how this could possibly be happening?

Thanks in advance.

Robert

We are using 3.7.

Robert,

Is there a custom MFS attached to this table? How about a relational index pointing to this column?

dbakke@srpcs.com

SRP Computer Solutions, Inc.

Additionally, field 25 of the dictionay record could be set to 1. This will also prevent changes to the field.

The Sprezzatura Group

World Leaders in all things RevSoft

View this thread on the forum...