>Roi, I ahve code in like : select v_kma, append blank which I thought just appended a blank record to the VIEW. I have not (on purpose at least) update the Base table anywhere... am I missing something ??
>
>
That's the way it should work. You should get that error when you issue a tableupdate() on the view and all the fields are blank.
>>>2. I have a from which uses a parameterized updateable view.
>>> I am not using the data Environment (instaed I open all files on a startup routine) , but message keeps coming up to enter a value in the parameter field (?lcField)
>>
>>If the parameter is ?lcField you need to put a value in it prior to using it.
>>
>>lcField = "123"
>>use MyView
>
>
>Wold this typically be done 'in the form' or when I initially open my table.
>If on the form where in the form
>
You can put it anywhere really. Upon advice from some of the other users here I store it in a property on the form and put the views in the DE (with NoDataOnLoad = .t.).
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!