TestComplete executes the SQL Query but returns Empty value

[SaravanaKumar_N]

Hi Guys,

Greetings!!

I've a problem with TestComplete executing the Query. This is my query..

select testfield from [db-name].tablename

The problem is I've the Database name created with hyphen "-". In SQL Server management, if we have a db name with hyphen then we can use the square brackets [] to query the required value. But in Test Complete it returns a "Empty" value. 

Can someone help me to fix this problem?

Thanks in Advance,

~ Saravana.

[SaravanaKumar_N]

I figured out that the problem is not with TestComplete. Sorry for wasting your precious time.

[rudraw]

What was your solution, if you could share please.