@bensat2
Please follow the below approach.
Code:
SET StrConnect TO $'''Connect'''
SET Create TO $'''sdds'''
Database.Connect ConnectionString: $'''Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Fruits;Data Source=DESKTOP\\SQLEXPRESS''' Connection=> SQLConnection
@@copilotGeneratedAction: 'False'
Database.ExecuteSqlStatement.Execute Connection: SQLConnection Statement: $'''SELECT [Pub]
,[date]
,[pm]
FROM [Fruits].[dbo].[Stocks]
where (Pub= \'%Create%\')''' Timeout: 30 Result=> QueryResult
IF QueryResult.RowsCount <= 0 THEN
EXIT Code: 0
END
Display.ShowMessageDialog.ShowMessage Title: $'''test''' Message: $'''test''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
Thanks,
Deenuji Loganathan 👩💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥
-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀. If you'd like to appreciate me, please write a LinkedIn recommendation 🙏
