General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>The UPDATE is not working as I would like. For a different example. Table1 has SSN and LastName. Table2 has SSN and LastName and is used to update LastName in several tables. Not all the records in Table1 will be in Table2 and not all the records in Table2 will be in Table1. If Table1.SSN = Table2.SSN and Table1.LastName = Table2.LastName I want to replace Table1.LastName with Table2.LastName.
>>
>
>VFP's version of UPDATE can't do this. Use REPLACE FOR.
>
>Tamar
That sure seems to be true, Tamar. I guess that since the documentation doesn't explicitly say it can be done, then it is only fair to conclude that it can't, as you state.
BUT, this being a limitation of the current UPDATE - SQL, it sure would be helpful to get an error when one specifies (or tries) something beyond its capabilities.
Maybe you can note this in your next Hacker's publication.
JimN
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only