sql - error deleting content that matches the result of a Select in ODBC -
i working odbc driver, , trying delete old comments database. getting error , don't know why. tables exist , accessible me.
delete [z_test_pnt.pnt_comment_record] [z_test_pnt.pnt_comment_record].[l2key] in (select point.queuekey [z_test_pnt.pnt_header_record] point (datediff(day, point.last_update_time, now()) > 7))
i error:
[odbc eop driver][openaccess sdk sql engine]base table:z_test_pnt.pnt_header_record not found.[10129]
i appreciate suggestions. thank you.
found it! needed remove brackets table names. added them in first place because having error running query vbs, , thought error couldn't have name more 1 dot on it. code works:
delete z_test_pnt.pnt_comment_record z_test_pnt.pnt_comment_record.[l2key] in (select point.queuekey z_test_pnt.pnt_header_record point (datediff(day, point.last_update_time, now()) > 7))
Comments
Post a Comment