SQL Assistant 15.00 TD 14.11.0.1 Doesn't Properly read first Parameter Key

Tools
Enthusiast

SQL Assistant 15.00 TD 14.11.0.1 Doesn't Properly read first Parameter Key

Hi TD Forum,

I am running on TD Ver 14, and have SQL Assistant 15.00, and when I run a query that has a prompt for two dates to be inout bythe user, the paramter promts of something like:

where date_col between '?date1' and '?date2'

The 2nd date prompt is read, but the 1st one is not and always errors (it even highlights oddly), I have to hard code to get around. I try to re-type it in case a strange font is not being recognized, but nothing works.

In my SQLA Tools, Options, Query, I have the 'Allow Named Paramters' checked.

Any work arounds for this issue?

Thanks

2 REPLIES
Enthusiast

Re: SQL Assistant 15.00 TD 14.11.0.1 Doesn't Properly read first Parameter Key

Bump - No one has seen or heard of this?  Update, seems to random, some queires it not an issue, others it is. I have tried things like retype it, but also copy/pate into Notepad to strip off any weirdness, and then copy/paste back, plus doing that in Word and giving it a generic standard font, but that doesn't get around SQLA not reading the prompt correctly.

Teradata Employee

Re: SQL Assistant 15.00 TD 14.11.0.1 Doesn't Properly read first Parameter Key

Which patch level of SQL Assistant? There was a fix related to quoted named parameters included in 15.0.0.4