Global update of column based upon contents of another table
I need to update a table with a date field that is calculated from the contents of another table.
I have a table that stores ticks for a persons birthdate (demographics)
I want to be able to take the id and birthdate from the demographics table and update/insert into a second table with the
id = id
I've been able to create the connections to the tables but i have not been able to figure out how to just update the contents of a column based upon an expression withouth going through the records one by one.
Do while .not. eof()
table2.id = table1.id
table2.birthdate = datetime.frombinary(table1.birthdate.tostring)
I'm not much of a programmer and I was hoping vb 2008 would be easy but I appear to be hitting a big learning curve on "global" updates..