sure sir.

following is my proc code. proc is taking comma separated input string . it get parse and then compare to db table. if product(s) are invalid , i sent...

Thank you. TRY_Convert exist in my version

Thank you All for input.

issue is resolved, it looks like ODBC issue but really not sure.

we added connection open/Close on every sql statement in application and apparently it looks fixed...

Dev said he used default settings. I got following on login Audit (profiler), not sure if this can help

-- network protocol: TCP/IP

set quoted_identifier on

set arithabort off

set numeric_roundabort off

set ansi_warnings on

set...

This part of application is developed in Omnis

I need to confirm ODBC version, Yes windows server upgraded some time back

What type of application? MS Access by chance? I do...

• This reply was modified 3 years ago by  thbaig.

This table has no FK constraint , as this is base table and having PK only

It's just an INSERT for C.R.U.D.  I suspect that the inset is sometimes being...

No trigger on this table

no , app is not calling it in loop, but this could call several times in a sec

I have not defined any cursor. But may  be it is throwing error due to implicit cursors by rdbms , that is the reason for suggestion about SET NOCOunt ON...

• This reply was modified 3 years ago by  thbaig.

Thank you Phil.

but why the addition of "@myFlag <> 1)" make it work ?

(@myFlag <> 1)

OR

(

@myFlag = 1

AND name NOT IN ( 'A', 'C' )

);

DROP TABLE...

If following is as per suggestion, it return all...

No. It return all rows all time.

I have updated description