I tried running some SQL queries that don't return any result when using them via SQL on a Sybase database:
if exists(select * from MyTable where Value ='SomeValue') select 'The value exists'
I verified that the query works, but when running it with ADO through a recordset or command object I get no results.
Is this an ADO limitation ?
Is there another way to do it ?