Hi Gerard,
I just started using views myself but I might be able offer some insight.
>1. Sometimes I get a message,
> Cannot insert an empty row from a view into its base tables
>
If you append a record to a view you need to change at least 1 field before updating the base table. To get out, issue a tablerevert(.t.).
>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
hope it helps.
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!