cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

Use table name as parameter for SQL command and SQL query

seanccc
17-Peridot

Use table name as parameter for SQL command and SQL query

Hi, 

 

How to use table name as parameter in Database thing for SQL command and query ?   

I tried something like : select * from [[tableName]],  but it doesn't work. 

 

Regards,

Sean

1 ACCEPTED SOLUTION

Accepted Solutions
nmilleson
17-Peridot
(To:seanccc)

Try this instead:  select * from <<tableName>>

View solution in original post

3 REPLIES 3
nmilleson
17-Peridot
(To:seanccc)

Try this instead:  select * from <<tableName>>

seanccc
17-Peridot
(To:nmilleson)

@nmilleson ,

 

Thank you for your quick reply.  I just found it as well and posted it before refreshing the page :  ) 

 

Regards,

Sean

seanccc
17-Peridot
(To:seanccc)

I found the answer in https://developer.thingworx.com/en/resources/guides/external-databases . 

 

Just use <<tableName>> in SQL  

 

Regards,

Sean

Top Tags