> Is there any way you could create a view on the > Pervasive side that retypes > the offending fields and use that view?
I think he needs to update the data, and a view which used functions to convert the types would not allow updating of those columns. But you could combine this with Bill's suggestion: 1. Use a view to display the values (convert them to text, or something). 2. Use properly formed Pervasive SQL to push UPDATE statements to the Pervasive database to change the data. More work than simply binding a form to the SATTACHed table, but it might be what you need to do. -- Larry
