>OK, I'm a little new at this but I have created a view which uses three other tables to extract information that meets a particular criteria. Once I am satisfied with the data, I want to globally go back and change two fields in the source tables that serve as flags for each record in the view using the UPDATE command. I tried to construct one but keep getting a syntax error. I tried this
>
>UPDATE sourcetbl1 SET column3="0001"
>WHERE viewtbl.column1=sourcetbl1.column1;
>AND viewtbl.column2=sourcetbl1.column2
At first glance, here are a couple of things...
You have no semicolon at the end of your first line
Since there is no space between "column1" and the semicolon, without a space before "AND" at the first line, VFP will interpret the line as:
WHERE viewtbl.column1=sourcetbl1.column1AND viewtbl.column2=sourcetbl1.column2
Christopher
Christopher Estep
When the student is ready, the master appears.
-- Chinese Proverb