Trying to write this SQL statement

Question

question

Patrick Cloutier asked Dec 13, '21 Patrick Cloutier answered Dec 14, '21

Trying to write this SQL statement

I'm trying to write this SQL Statement but there is a problem with the line before last:

Table result = Table.query("SELECT * FROM FRList1 \
WHERE [ChoiceC2] > 0 \
AND [Content] > 0 \
AND [Content] < 10 \
AND 'token.item.Purity' = [Purity] \
ORDER BY ChoiceC2 ASC");

token.item.Purity is a string label and [Purity] is a string column in my table.

But I never get a match because of that line although there are matches that I can see.

Is my synthax correct?

Thanks a lot,

Software Version:

FlexSim 21.2.4

sql query

· 3

Matthew Gillespie ♦♦ commented · Dec 13, 2021 at 09:08 PM

@Patrick Cloutier It doesn't know what token is.

0 ·

Patrick Cloutier Matthew Gillespie ♦♦ commented · Dec 13, 2021 at 09:10 PM

How do I write it then?

0 ·

Patrick Cloutier Matthew Gillespie ♦♦ commented · Dec 13, 2021 at 09:29 PM

I've spent hours in the manual and on w3schools and I can't figure it out...

0 ·

Answer 1 · 2021-12-13T21:34:29Z

Patrick Cloutier answered Dec 13, '21

I found it !!!

Table result = Table.query("SELECT * FROM FRList1 \
WHERE [ChoiceC2] > 0 \
AND [Content] > 0 \
AND [Content] < 10 \
AND [Purity] = $1 \
ORDER BY ChoiceC2 ASC", token.item.Purity);

question