Hello - I am new to Toad Data Point and am trying to figure our how to use a prompt value in the query results.
I know that I can set up a prompt in the query using a “:” (e.g. :SnapshotDate). However, lets say I want the :SnapshotDate to appear as a field in the query results as well.
In prior versions of TOAD…you could set up a prompt using & (e.g. &SnapshotDate)…and then call the prompt value in the query itself by listing &SnapshotDate as a field. Similar to this… SELECT Name_, &Snapshot_Date FROM MyTable
It is not working for me in Toad Data Point using :SnapshotDate in the Select statement and as a prompt in the Where clause.