Database

In my opinion , if you can create log table in your database. A easy way is insert the sql into your log table. e.g. Create log table: CREATE TABLE SQLLOG_DEBUG ( SQL_LOG VARCHAR2(4000 BYTE) ) Insert the sql into your log table. INSERT INTO SQLLOG_DEBUG (SQL_LOG ) VALUES (ssql ) *This is just a sample, I didn't test the code. If the sql is big , you can change SQL_LOG's datatype into clob. You can also use DBMS_OUTPUT.PUT_LINE and redirect the output to a file. The following page shows how to do it. [stackoverflow.com]

No - I cannot bypass the firewall using some dodgy download. What makes you think our corporate security is so weak it would allow me to do that :laugh: Why not just do what thousands of other members do - type in the details into a post?

It's a WPF app, which creates a new entity and sends it to the API. When the API call returns, I am now passsing back the Guid and assigning the new entity. Thanks If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.

DerekTP123 wrote: rather than just a later version. It's a real shame, because 15 years ago when I first started using them I suspect that 15 years ago you also were different. So could be that they have gotten worse but could also be that you have become more discerning. Or a combination.

Perhaps you missed my point. You have a list of pointers. Nothing more. The pointer must be set to point to something. Where does that happen? normga wrote: the code always query mysql successful That doesn't mean anything. Code can run successfully, sometimes, even with uninitialized pointers. It depends on how the memory is laid down.

That's something for our DBAs to worry about. :) ".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

It lets you replace [MyDB].[dbo].[MyTable] with a shorter name, such as a: SELECT a.* FROM [MyDB].[dbo].[MyTable] AS a You can also use the aliasiing feature on column names, like so: SELECT [MyReallyLongColumnName] AS ShorterName FROM [MyDB].[dbo].[MyTable] A simple google search will give you all the nuances regarding the use of aliasing in SQL Server (for columns, sometimes you should, sometimes you must, and sometimes you don't have to use aliasing. BTW, you generally alias table names when using join or merge. ".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

Kevin Marois wrote: So what if I created a PK table on the sever: In this scenario... (some caller) -> (app server) -> (database server) In the above the 'app server' is the 'client' for the 'database server' If you create the key on the 'app server' then you have the following choices (locking in your code has no impact on this.) 1. There can only be one server. 2. You will need to create/find a mechanism the correlates the id creation between multiple 'app server' instances.

SQL Tutorial[^]

We cannot share same solution..this site for sharing our knowledge and experience to find best and alternate solution to reach OP's expectations.I always try to understand others i hope u too :-)

Well, I have checked & rechecked all the settings.. Named Pipes s disabled everywhere that I can see. Still getting this error If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.

it's right.Thank you,dude.The column 'contractNo' has null value.

You still have options: - edit the question and add further information. - reply to the person(s) who have already responded with some feedback or requests for more assistance.

Maybe you should rewrite this query into its separate clauses so you can see the breaks more clearly. You have a number of parts where you are concatenating text and variable fields so it may be that you have unbalanced quote characters.

Check that the ID on the ServerList table is the same as i. i will be 1 then 2 then 3 etc I bet the ID field in servertables does not match. Try using a cursor and looping through the servertable. Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP

It's always easier to help sort problems out if you also supply some sample data and expected results. You are using the TEXT datatype for some key data items - this allows up to 2GB of text and is the wrong choice for things like names, emails etc. You also cannot compare or sort easily. Use Varchar instead e.g. VARCHAR(MAX) (Although that is also overkill, I usually use varchar(50)) You are using WHERE when you should be using CASE WHEN ... END

from the original data I created the result, if the contract in the month has LOAIHD = "FBAN" and between (#01/01/2019# and #31/01/2019#) then [BOOL] = 1 else [BOOL = 0, I will describe the condition of [BOOL] in C# code [CODE] for (int i = 0; i < [Original data].Count; i++) { bool BOOLEAN = 0; string SOHD = ""; if([NGAYGIAO].[i]>=#1/1/2019# && [NGAYGIAO].[i] <=#1/31/2019#) //dd/MM/yyyy { for (int j = 0; j < [Original data].Count; j++) { if([LOAIHD].[j] == "FBAN") { BOOLEAN = 1; SOHD = [Original data].[HD].[j]; } } } if(SOHD == [Original data].[HD].[i] && SOHD != "") { [Result].[BOOL].[i] = BOOLEAN; } } [/CODE]