>When executing the following line, I get an 'Alias "OLICENSERCD" is not found' error. It's treating the container hierarchy as if it were a reference to a table. It doesn't happen for the properties that just have a THIS. reference. Also, when I place the cursor over the this.oLicenseRcd.Orig_Lic reference in the Debug window the correct value is displayed.
>
>update tls_License set ;
> SERVICECLASSID = this.ServiceClassID, ;
> EFFECTIVEDT = dtot(this.oLicenseRcd.Orig_Lic), ;
> NOTES = alltrim(this.oLicenseRcd.Comment), ;
> RECEIVEDDT = dtot(this.oLicenseRcd.Orig_Lic) ;
> where LICENSEID = this.LicenseID
>
>Any help appreciated...
Ahh, well you included the code and showed it was a matter of "update SQL". Unfortunately update SQL parses that way. You better assign those values to local vars and use them instead.
Cetin