I have a problem with using ‘advanted’ queries.
I have working keywords with connect to mssql and mysql databases
I can do method who execute ‘basic’ queries like
select * from table1
update bla bla
gropu by having order etc.
but i have problems with query who have transact sql (t-sql)
My eg. query like :
@declare variable 1
sel;ect * from where a = @var2
i think its driver problem.
this its not work with heidi sql default profile, heidi cant execute tsql.
So what i need to do ??
From katalon dosc example :
package com.database import java.sql.DriverManager import java.sql.ResultSet import java.sql.Statement import com.kms.katalon.core.annotation.Keyword import com.mysql.jdbc.Connectionwhat i need to import and using I need to create new conn executing methots and close connection. Any ideas ?