Hi, I’m trying to run the following SQL query with variables (arguments), but even before running it, I get the error that a string must end with a double quote. I tried to insert the double quote in several ways, but I didn’t find sofar the correct way: "Select Hot.H_KEY, Hot.H_NAME1, Hot.H_STRA…

This is the fixed version. I needed to put some extra spaces at the beginning of each piece: “SELECT " + _ “Hot.H_KEY, Hot.H_NAME1, Hot.H_STRASSE, Hot.H_PLZ, Hot.H_ORT, LND.L_LAND” + _ " From HRSDB.HOTEL Hot inner Join hrsdb.laender LND On Hot.l_id = LND.l_id” + _ " Where " + _ “H_NAME1 = '”+i…

Error in string definition of a SQL Query with variables

Help Studio

ppr (Peter Preuss) May 18, 2022, 4:11pm 13

OK, looks like the general issue was indentified and handled. So the topic can be closed by you
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum

Topic		Replies	Views
Using Variables in a SQL Query - String Commands must end in Double Quotes Studio datatable , studio , question , sql , activities_panel , variables_management , sql-stored-procedure , fetch-sql-data	11	3474	April 14, 2022
String format error Studio studio , question , activities_panel	8	2277	January 26, 2024
String constants must be in quote .Error Execute Query. Part II Activities database , activities , question , sql	7	2913	September 10, 2021
Double Quotes in sql in uipath Help	13	4307	July 14, 2023
Run query Activity Studio studio , question , designer_canvas	8	1003	July 22, 2022

Most Active Users - Yesterday
ashokkarale
Yoichi
pikorpa
JenJen
dokumentor
A_Learner
michael.db.1990
Jaeyoung_Jung
Ashutosh.Gupta
Phenyo
More details...

Error in string definition of a SQL Query with variables

Related topics