>Dear all,
>
>I have this problem with update statement giving an error. I have a text box in container object and this is referenced (mydate) in the UPDATE statement with error out with "Alias is not Found". Is this a bug??
>
>Table struture
>
>Field1 CHAR(10)
>Field2 DATETIME
>
>*******
>oCon = CREATEOBJECT("container")
>oCon.AddObject("mydate","textbox")
>
>UPDATE tab1 SET mydate = oCon.mydate.value WHERE field1 = 'A'
>
>******
>
>
>Thanks.
>
>Regards,
>Kueh
Kueh,
It's a known issue.
ldValue = oCon.mydate.value
UPDATE tab1 SET mydate = ldValue WHERE field1 = 'A'
works.
Cetin