coding problem

[huntert]

I have this coding problem with the line of code not being interpretted correctly thus I must be doing something wrong
There are three global variable:
1) glDBName ..character
2) glcTemp ..character
3) glptid ..number

and one local variable
4) ctemp ..character

I know these variable are being transfered to the routine correctly. The glcTemp I think is the area of problem. The SET glcTemp is not being interpretted as SET (variable value) stating that the column glcTemp does not exist. I have tried to put this into () but I get a expression error that the Update is no longer valid statement occurs. How can I get this Update statement to be interpretted correctly? Thanks alot in advance. hunter

UPDATE (glDBName+"!PtData") SET glcTemp = ctemp WHERE Pt_Id = glptid

 

[bborissov]

UPDATE (glDBName+"!PtData") SET &glcTemp. = ctemp;
       WHERE Pt_Id = glptid

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[huntert]

Thanks for the simple solution. I did not know about this conversion. hunter