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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Order of SQL Execution in Crystal.
I have determined a way to get this by just doing {?Schema}.table_name. Thanks for the help Turkbear.- olsen85
- Post #4
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Order of SQL Execution in Crystal.
Thanks for the response. The alter table SQL statement does not show up in the 'Show Sql' option, and I have been unable to create a command with both an alter session statement and a select statement in one. The reason for the need for this is that we have a single database with different...- olsen85
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Order of SQL Execution in Crystal.
I am running Crystal Reports XI with a connection to an Oracle 10g database. I want to add a custom command to my report to do something like 'alter session...' and have it run before any selects. I was wondering if anyone knew in what order will Crystal process the SQL statements and if there...- olsen85
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 2 Data Access
