Help with UPDATE QUERY please

[foxup]

UPDATE QSource FROM q1 SET QSource.duration = q1.max_dur WHERE QSource.usoc = 'HOST' AND QSource.groupid = q1.groupid


unrecongnixed command phrase?


Please help

 

[Mike Lewis]

Can't see anything wrong with your syntax. Are you sure you pasted it exactly as it was in your code?

Also, I don't recognise that error message. The nearest valid message is "Unrecognized command verb" - which suggest that the first word of the command is wrong ("update" in this example). But that doesn't seem to be the case here.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[foxup]

yes, positive. and it is verb not phrase, but I don't see the err either??

 

[Dan Freeman]

Are you sending that update to a remote data source using SQLExec()?

"Verb" is not a Foxpro concept.

 

[Mike Lewis]

It's probably something quite simple. I'm just clocking off for the day. By the time I get to work tomorrow, no doubt someone else here will have given you the solution.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[foxup]

no to dan

i hope so to mike

 

[Olaf Doschke]

VFP does not give a syntax error, at least VFP9.
SQL Server expects FROM after SET, so try

UPDATE QSource SET QSource.duration = q1.max_dur FROM q1 WHERE QSource.usoc = 'HOST' AND QSource.groupid = q1.groupid

AFAIR this is not working in VFP6 and 7, can't say about 8. Correlated updates (updates of one table with data from another one) came rather late into the vfp sql engine, as simple as it seems.

Bye, Olaf.

 

[Koen Piller]

Hi,

unrecongnized command verb = error(16) - Advise to copy and paste command which causes this error once more and now complete. My 10 dollars this is case of a typo.

Jockey(2)

 

[Mike Lewis]

Foxup,

What version of FoxPro are you using?

The syntax is correct in VFP 9.0, but this form of the UPDATE command is not supported in earlier versions.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Olaf Doschke]

Error 16 can also occur on a multiline sql, if a semikolon is missing. This ends up in interpreting from the line after the missing semikolon to be taken as the begin of a new statement, eg if that occurs in the FROM line you get such an errror.

Bye, Olaf.

 

[foxup]

Hi All,

FYI, this is how I fixed this "freaking' bug:

UPDATE QSource FROM q1 SET QSource.duration = TRANSFORM(q1.max_dur) WHERE QSource.usoc = 'HOST' AND QSource.groupid = q1.groupid


TRANSFORM!! F&*% TRANSFORM!!

I thank you all for your time though! Many thanks to all who tried. Star for all of you!

Thanks,
Foxup!

 

[Olaf Doschke]

What's the type of Qsource.dration and q1.max_dur?

Even if they differ, that should not lead to "unrecognized command phrase", but a type error.

Nevertheless, if it's a type difference, there's nothing to curse about, but a misleading error.

Bye, Olaf.