Delete object reference in SQL custom query - JMP 17

[#1]

Hi,

I am trying to query data base by providing input parameter through a variable.

1] I am seeing below error for attached:

a = 666.1;
deleted object reference[]

How do i resolve this?

It works when I  use 666.1 directly here FROM fer_view2 t1 where(t1.DVT_id = 666.1)

a = 666.1;

show(a);

obj = New SQL Query(
	Connection( "ODBC:DSN=DVT Data Server" ),
	QueryName( "fer_view2" ),
	CustomSQL(
		"SELECT *
FROM fer_view2  t1 where(t1.DVT_id = a) ;"
	)
	
) << Run;
	

Also same thing happens when i create a text edit box to input value from user

[#2 · Accepted solution]

You will have to build the query string (currently you just have a there not the value). You can evaluate your variable there using Eval Insert (or use other methods)

a = 123;
Eval Insert("SELECT *
FROM fer_view2  t1 where(t1.DVT_id = ^a^) ;")

Eval insert uses ^ by default a startChar

[#3]

Thank you so much. It worked