Working with N1QL and Placeholders for the table name

Hey there,

I’m using Node 7.8 with this types and I’m not able to work with placeholders for the table name.

Here is my working pseudo code:

		let statement: string =
		    "UPDATE `" + TABLENAME + "` " +
		    "SET `graphsIDs` = ARRAY_APPEND(graphsIDs, $1) " +
		    "WHERE META(`" + TABLENAME  + "`).id = $2";
		
		let query = N1qlQuery.fromString(statement);
		
		do query with [param1,param2];

But I can’t use placeholders for the table name like this:

		let statement: string =
		    "UPDATE $3 " +
		    "SET `graphsIDs` = ARRAY_APPEND(graphsIDs, $1) " +
		    "WHERE META($3).id = $2";
		
		let query = N1qlQuery.fromString(statement);
		
		do query with [param1,param2,param3];

I tried to put the table name into ` or " or ’ but nothing is working.
Maybe this isn’t possible but should be? :wink:

This is not possible, and shouldn’t be :wink:

It is not supported in SQL either, as far as I know. You can build your query string dynamically and generate table names.