Viewing 15 posts - 1 through 15 (of 93 total)
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...
November 4, 2021 at 5:20 pm
Thank you. TRY_Convert exist in my version
November 4, 2021 at 10:20 am
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...
November 3, 2021 at 6:51 pm
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...
September 21, 2021 at 3:57 pm
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...
September 21, 2021 at 2:23 pm
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...
September 21, 2021 at 2:08 pm
No trigger on this table
Is there an insert trigger on WEB_ORDERS? Cursor could be lurking there.
September 21, 2021 at 1:49 pm
no , app is not calling it in loop, but this could call several times in a sec
September 21, 2021 at 1:48 pm
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...
September 21, 2021 at 1:14 pm
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...
May 6, 2021 at 11:55 am
November 28, 2017 at 12:38 pm
November 28, 2017 at 11:00 am
Phil Parkin (1/3/2017)
So do the left join and then use COALESCE to pick up t2 data if it exists:select ColName = coalesce(t2.col,t1.col)
If following is as per suggestion, it return all...
January 3, 2017 at 7:00 am
No. It return all rows all time.
I have updated description
January 3, 2017 at 6:50 am
Viewing 15 posts - 1 through 15 (of 93 total)