SQL Update Command VFP 6.0 1

[smandle]

Hello,<br><br>I am trying to update rows of a table with information from a second table. I am using &quot;Update&quot; to do this. My question is can I use subqueries in the update statement. Th manual says I can but I am unable to find success. Here is the code I am using and I have tried various other combinations. With this line I get the error &quot;Function name is Missing&quot;.<br><br>&quot;update hrpersnl set hrpersnl.workcomp = (select abra.parent_box from Abra where abra.ID = hrpersnl.p_empno)&quot;<br><br>Any help or a working example of the Update statement using a subquery would be appreciated.

 

[dgrewe]

Post the 2 dbf structures and the common indexes between them and I'm sure we will be able to help you. <p>David W. Grewe<br><a href=mailtoave@internationalbid.net>Dave@internationalbid.net</a><br><a href= > </a><br>

 

[manuelmonsalvez]

Hi!

I wanna make you a question. ¿Did you find the answer to your question, about Update SQL sentence in VFP?

tia.

Manuel Monsálvez V.
inteneg@ctcinternet.cl