johntillman — 2013-08-13T02:25:14-04:00 — #1
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';
r937 — 2013-08-13T03:41:40-04:00 — #2
didn't see your actual error message, but there's a semicolon before your WHERE clause in the first statement
johntillman — 2013-08-13T04:10:59-04:00 — #3
johntillman — 2013-08-13T04:16:41-04:00 — #4
Thanks but that did not help will try and attach error again. Ok think it worked that time it is a *.gif