Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can we update - Database-> Show SQL Query
- Thread starter kutoose
- Start date
synapsevampire
Programmer
Open it, it states what you can edit from within there:
From
Where
Order By
If you want to use SQL created elsewhere, then use an ADO or RDO connection and paste in your SQL.
This assumes that you're speaking of CR 8.5, please add environment information when posting.
-k
From
Where
Order By
If you want to use SQL created elsewhere, then use an ADO or RDO connection and paste in your SQL.
This assumes that you're speaking of CR 8.5, please add environment information when posting.
-k
- Thread starter
- #3
If you're using CR9 then you have the ability to create SQL commands, which should give you much greater flexibility. SQL commands allow you to create full-fledge SQL statements (much like a View or a Stored Procedure) and then use those commands as if they were tables.
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question