topic Trying to write this SQL statement in FlexSim Forum

Trying to write this SQL statement

patrickABAWF — Mon, 13 Dec 2021 21:05:53 GMT

[ FlexSim 21.2.4 ]

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,

Re: Trying to write this SQL statement

Matthew_Gillespie — Mon, 13 Dec 2021 21:08:23 GMT

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

Re: Trying to write this SQL statement

patrickABAWF — Mon, 13 Dec 2021 21:10:22 GMT

How do I write it then?

Re: Trying to write this SQL statement

patrickABAWF — Mon, 13 Dec 2021 21:29:39 GMT

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

Re: Trying to write this SQL statement

patrickABAWF — Mon, 13 Dec 2021 21:34:29 GMT

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);