Trying to run the following in a DBISAM database, get error attached. Program3 is the heading in the field. If you need the data base please advise as I cannot get it to attach here.
newbe on this forum.
SET Product.ProductGroup = ProductDetail.Program3
FROM Product INNER JOIN ProductDetail ON ProductDetail.ProductCode = Product.ProductCode;
WHERE PG_description = 'Unassigned';
SET Product.StockUnit = StockUnit.StockUnit
FROM Product INNER JOIN StockUnit ON StockUnit.ProductGroup = Product.ProductGroup
WHERE SU_Description = 'Unit';
didn't see your actual error message, but there's a semicolon before your WHERE clause in the first statement
Thanks but that did not help will try and attach error again. Ok think it worked that time it is a *.gif
This topic is now closed. New replies are no longer allowed.