cancel
Showing results for 
Search instead for 
Did you mean: 

New JDBC Connection issue

Former Member
0 Kudos

Hi All,

I was able to add my new JDBC connection with no problems but I think I left something out. Here's the issue:

I can access the database until I try to put in a where clause or filter. When I look at Show Query, I should see thisin my where clause:

AND "tickets"."ticket_type"='IM'

I get this:

AND "tickets"."ticket_type"=N'IM'

I didn't put that into the select expert criteria so I'm not sure how it is being added into the query. Anyone have any ideas?

Thanks in advance,

Sandie

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Please re-post if this is still an issue to the Data Connectivity - Crystal Reports Forum or purchase a case and have a dedicated support engineer work with you directly

Former Member
0 Kudos

Hi there,

There are a couple of things that were not indicated in your question

1. What kind of database are you using?

2. What version of Java are you using?

As for suggestions, what happens if you use a Command Object to explicitly state the SQL that you would like to use? Does it illustrate the same behavior?