Here the solution,

Dynamic SQL, meaning, it can be huge. the joins or inside the WHERE clause you have to use NULL saying "AND ( attribute IN ( 'your values'...

I found the problem. In a where condition, I am passing the string "NULL" as follow:

AND IN ( 'N', 'n', NULL)

if I remove the NULL then everything...

event though your dynamic sql return different columns every time, you should include primary/foreigner keys in your result set or temp table otherwise how will you link that information to...

Imaging two tables "codes" and "reports" where codes is a common table having descriptions and reports has a column having a code and you want to display the description of...

I am using Sybase 12.5, XP, VS .NET 2005, using DAAB or normal DATA.* namespace. Connection Strings are below.

Inside your app.config or web.config; connectionStrings section:

*ASE ADO*

"Data Source=IpAddress;Port=PortNumber;UID=UserId;password=Password;Database=DatabaseName;"

*OLE DB*

"Provider=Sybase.ASEOLEDBProvider.2;Data Source=FileName.IDS;password=Password;database=DatabaseName;uid=UserId;"

*ODBC*

"Driver={SYBASE...