When I have a parent-child relationship within my access data tables, such that RECORD.PARENT RECORD.ID within same table RECORD, I am having problems updating certain values within child record from values within parent record.
Columns: ID (primary key int), PARENT (foriegn key int), SHARED_VALUE (varchar)
I would like to run a query such as:
update RECORD as childRec set RECORD.SHARED_VALUE =
(select SHARED_VALUE from RECORD as parentRec
where parentRec.ID = childRec.ID)
However, HXTT does not recognize the table alias within an UPDATE query, and issues parsing error "Syntax error: Stopped parse at as". Any recommedations or plans on supporting table alias within update queries?
Correction... the inner sub-select should have read "where parentRec.ID = childRec.PARENT" - sorry.
Please download the latest package after about 3 hours. You should use
update RECORD as childRec set SHARED_VALUE =(select SHARED_VALUE from RECORD parentRec where parentRec.ID = childRec.ID);