686415_en-US

liliconcom

Delete object reference in SQL custom query - JMP 17

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

Automation and ScriptingData AccessWindowsRe: Delete object reference in SQL custom query - JMP 17

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

Re: Delete object reference in SQL custom query - JMP 17

Thank you so much. It worked