cancel
Showing results for 
Search instead for 
Did you mean: 

Print SQL Statement

Former Member
0 Kudos

Post Author: Fedor

CA Forum: Data Connectivity and SQL

Somebody knows, how can I print the currently SQL statement?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Post Author: V361

CA Forum: Data Connectivity and SQL

Go to database, Show SQL Query, highlight the query, RIght Click and select copy, then you can paste that into word, or excel, or text file. An example is pasted below.

SELECT `Customer`.`Region`, `Customer`.`City`, `Customer`.`Address2`, `Customer`.`Address1`, `Customer`.`Customer Name`, `Customer`.`Postal Code`, `Customer`.`Country` FROM `Customer` `Customer`

Former Member
0 Kudos

Post Author: Fedor

CA Forum: Data Connectivity and SQL

(in Crystal Reports XI)