Hi, I try this SQL statement on

[murphyc]

Hi,

I try this SQL statement on VFP command windows.

UPDATE INVOICE SET COST_STD = (SELECT STDCOST FROM PRODUCT WHERE INVOICE.PRODUCTID = PRODUCT.PRODUCTID)

VFP prompt this error message
[Function Name is missing).]

What's wrong on this statement? Please help!!

 

[Mike Gagnon]

murphyc

What's wrong on this statement?

It depends what you want to do. Normally the update sql requires a where clause if there is a condition attached to it. Take a look at the help file on UPDATE SQL.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Lewis]

MurphyC,

Which version of VFP are you using? I believe the ability to set a value equal to the result of a SELECT is only supported in recent versions. I'm not completely sure about that ... perhaps someone else can confirm.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[murphyc]

I use VFP 6.0

 

[Mike Lewis]

MurphyC,

On reflection, I think Mike Gagnon is right. You need a WHERE clause to link the SELECT to the UPDATE. Otherwise, how would it know which product belonged to which invoice?

Mike





Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk