Help with Databases and multiple tables
Posted on 2001-06-21
I haven't done much development with databases so I need some help.
I have two Access databases. I need to look in the registry for a certain value
sLocale := jciRegsUtil.GetRegStringValue(TOOL, 'AimVer', 'LocaleName', '');
and search my Logistics table(Warehouse database) for records with sLocale in the Area field and add these records to my Contact table (Address database).
I was going to try using the BatchMove component with the batAppend, but I believe that would append the entire second table. Is there a way to use a select statement in a query and then the BatchMove to add the records from the select statement?
Any help/code would be appreciated :)