You've to tableupdate the view but if table is buffered than you have to issue tableupdate() on the base table also.

>Should I tableupdate() the view or the base table????
>
>Regards
>Geoff Scott
>
>>Make sure that IIF returns a string of the same lenght regardless of condition.

CREATE SQL VIEW vWoItems AS ;
>>	SELECT Woitems.*, ;
>>		Contsub.prsched, Contsub.name, ;
>>		Prodserv.desc, Prodserv.unit, Prodserv.type, ;
>>		IIF(ISNULL(vlocations.locdesc), ;
>>                  PADR('**Unknown**', LEN(vlocations.locdesc)), ;
>>                      vlocations.locdesc) as locdesc, ;
>>		IIF(ISNULL(vwo_istatus.statusdesc), ;
>>                  PADR('**Unknown**', LEN(vwo_istatus.statusdesc));
>>                    vwo_istatus.statusdesc)  as statusdesc ;
>>	FROM wots!woitems ;
>>...
>>

BTW, ISNULL() alreday returns logical value. There's no need to compare it to .T.
>>
< snip >