How to dynamically pass column name into the SQL Query?

[asb_praneeth]

[ FlexSim 17.0.13 ]

Hello

I am trying to write a query in which I want to query certain column of the table based on Item name. This is the following query which I am trying but it is not working

string myName = item.name;
query("SELECT * FROM $1 WHERE [$3] > 0 AND ([Operator] = $2 OR [Operator] = 'AnyOne')"
,reftable("ML1_TaskListTable"),i,myName);

Task	Description	PartA	PartB	PartC
1	sdf	0.25	0	0.25
2	d	1.25	2	0
3	a	0	0	3.06
4	h	3	1.75	0

Thanks in advance,

Praneeth Akondi

[Jacob_Gillespie · Accepted solution]

Just insert the string using the + operator:

string myName = item.name;
query("SELECT " + myName + " FROM $1 WHERE [Operator] = $2 OR [Operator] = 'AnyOne'"
,reftable("ML1_TaskListTable"),i);

[mischa_spelt]

A little safer is

"SELECT [" + myName + "] FROM $1"

in case myName happens to contain a space.

[asb_praneeth]

Thank you...! It is very basic... ! But I couldnt get it at the time of coding...!