What is the SQL that created the view? I could be off here but I'm thinking that a view created with SELECT * would be susceptible to this where SELECT myfield1,myfield2 would not as long as your structural changes didn't eliminate fields that existed in the base table.
>Has anyone seen the Field Ordering affect a TableUpdate() from being successful?
>
>I am modifying my table structures on the fly out in the field for an update and apparantly if the Views are in a different field layout order the TableUpdate fails. Am I doing something wrong here or what? I am totally baffled! The ARRORS() shows an Error 107. Data type mismatch.
>
>TIA
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05