How do you update Freehand SQL Script in a Dataset once it's initially entered?

[Former Member]

We are successfully creating SQL Server connections via Lumira and the freehand SQL is working.  How do you go back and edit the SQL script once it's been saved?  By selecting the Dataset, then use the "Data" pull down menu and selecting "Edit" we can see the SQL script, but it is grayed out, so it cannot be edited.  There must be a way to go back to it and edit it (for example, to add a SELECT statement or a JOIN).  There must be a way - right now all we can do is create a new one manually be re-entering the connection and SQL script.

[achab · Accepted solution]

I am sorry Paul but I think not possible right now. Please vote the idea here: Ability to change free-hand SQL statements : View Idea and see the encouraging comment from Sharon.

BR,

Antoine

[achab · Accepted solution]

I voted this idea myself 😉

[Former Member]

Thanks for linking me to the Idea - I have voted now also.  Appreciate the follow up.