I have imported a file into Fox and am faced with several 8.0 numerics that I must convert to dates. I've parsed the field and performed queries to build a table containing the date field in the format that I wish, but I've always had problems with the update queries. How can I update "newfield" in table a with the corresponding date values from "converted_field" in table b where a.otherfield = b.otherfield and a.otherfield2 == b.otherfield2? Is this simple enough to be done with a few select-update queries, or will I have to build a more complex .prg?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.