Hi Jeff

I am not sure what you mean by “old box”. I would assume that you meant “old computer”.

Actually I do not remember the settings in my old computer (...

Thank you, chandrachurhghosh.

Thank you very much, jezemine and Grant.

Thank you, David.

I can obtain the information that all downloadable items were downloaded by the client by verifing the field “RemoveRole” in the CustomerDownload table ( not shown here )...

Oops, I forgot to add  two more observations:

3) I am using the above procedure to set the field “Completed” to “True” in...

Hi Anders

I just found out that the procedure is fine. The error actually was in a method that was passing the value of a wrong variable.

Thank you, anyway.

Thank you Chuck.

Hi Chuck

I solved the problem by modifying the code as below.

Now I want to know how to use EXISTS instead INNER JOIN...

Thank you all for your help.

Hi MohammedU

I tried your code but it is throwing an exception error.

Here is the method that call this procedure:

Let me explain better.

Yes, it has the “CartoonID” column (field ) that is set with identity starting from 1 and increasing by 1.

There is...

Hi Sreejith

Yes, it has the “CartoonID” column (field ) that is set with identity starting from 1 and increasing by 1.