2 Replies Latest reply on May 14, 2017 3:26 AM by wimdecorte

    Execute SQL

    lolli_group

      I am really interested in Execute SQL command in Script, it is the unique command in my lovely FileMaker I don't know well.

       

      So I tried but nothing.

       

      I have 4 Tables:

       

      1) QUOTE

      2) QUOTE_ARTICLES (RELATED with QUOTE_ID with 1) )

      3) BILL

      4) BILL_ARTICLES (related with BILL_ID with 3) )

       

      I want simply to do a bill equal to a quote, with same articles.

       

      I tried:

       

      INSERT INTO BILL_ARTICLES (COD_ART)

      SELECT COD_ART from QUOTE_ARTICLES WHERE QUOTE_ARTICLES_ID = $IDQUOTE

       

      Or tried:

       

      INSERT INTO BILL_ARTICLES (COD_ART)

      SELECT COD_ART from QUOTE_ARTICLES WHERE QUOTE_ARTICLES_ID = QUOTE_ID

       

      Nothing.

      Can you please help me? Where can I study best than the "FileMaker Execute SQL Reference" in PDF ?