MichaelHawksworth
IS-IT--Management
Hi Folks
The following code produces a "Function Name is missing )" error when run.
I am setting ctd_sPostCode from the postcode field from the curUpdate cursor where the account codes match.
Anyone any ideas?
Regards
Michael Hawksworth
The following code produces a "Function Name is missing )" error when run.
I am setting ctd_sPostCode from the postcode field from the curUpdate cursor where the account codes match.
Code:
UPDATE vw_contactdetails ;
SET vw_contactdetails.ctd_sPostCode = ;
(select ;
curUpdate.postcode ;
from ;
curUpdate ;
WHERE ;
ALLTRIM(curUpdate.accountcode) == ;
ALLTRIM(vw_contactdetails.ctd_sOrg) ) ;
where ;
ALLTRIM(ctd_sContact) == "HEADOFFICE" AND ;
ctd_sOrg in (select accountcode from CurUpdate )
Regards
Michael Hawksworth