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!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I modify SQL statement in ADO conn

Status
Not open for further replies.
franklin1232

franklin1232

IS-IT--Management
Aug 29, 2001
207
US
I have been forced into use an ado connection through ODBC because of problems with Crystal and it's direct interaction with my ODBC driver. So I put in a rather long SQL statement to build my ADO recordset and it works great, but opps I need to select one more field. I can't find a way to edit the SQL query. I have been adding a new connection which removes all my placed fields. I can't believe that I can't edit the SQL. The "show SQL query" under the database menu is grayed out. Version 8.5 DEV.

Thanks
 
Status
Not open for further replies.

Similar threads

JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
507
SoftwareRT
SoftwareRT
G
  • Locked
  • Question
Multiple groups in same level
Replies
0
Views
171
george1610
G
K
  • Locked
  • Question
We're using command in crystal report
Replies
1
Views
584
hilfy
hilfy
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
885
hilfy
hilfy
H
  • Question
Cannot get a sub-report to print without the headers and footers of the main report
Replies
1
Views
208
DjangMan
DjangMan

Part and Inventory Search

Sponsor

Back
Top