AnsweredAssumed Answered

Execute SQL

Question asked by lolli_group on May 14, 2017
Latest reply on May 14, 2017 by wimdecorte

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 ?

Outcomes