SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Aug 2013
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help with a basic sql in DBISAM

    Hi Folks
    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.



    UPDATE Product
    SET Product.ProductGroup = ProductDetail.Program3
    FROM Product INNER JOIN ProductDetail ON ProductDetail.ProductCode = Product.ProductCode;
    WHERE PG_description = 'Unassigned';

    UPDATE Product
    SET Product.StockUnit = StockUnit.StockUnit
    FROM Product INNER JOIN StockUnit ON StockUnit.ProductGroup = Product.ProductGroup
    WHERE SU_Description = 'Unit';

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,335
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    didn't see your actual error message, but there's a semicolon before your WHERE clause in the first statement
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Member
    Join Date
    Aug 2013
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by johntillman View Post
    Hi Folks
    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.



    UPDATE Product
    SET Product.ProductGroup = ProductDetail.Program3
    FROM Product INNER JOIN ProductDetail ON ProductDetail.ProductCode = Product.ProductCode;
    WHERE PG_description = 'Unassigned';

    UPDATE Product
    SET Product.StockUnit = StockUnit.StockUnit
    FROM Product INNER JOIN StockUnit ON StockUnit.ProductGroup = Product.ProductGroup
    WHERE SU_Description = 'Unit';

  4. #4
    SitePoint Member
    Join Date
    Aug 2013
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks but that did not help will try and attach error again. Ok think it worked that time it is a *.gif


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •