May be a "inherited form" will help you(I guess so) :confused:

Absolutely.

I have checked your code but it works in Windows 7 also!

Cross Post[^]

You may use the Comments and Discussions section below the article and add a new message to the article writer and ask what you more want to know.

Here[^] is a solution for you

http://www.codeproject.com/Questions/141370/Cheap-Web-Hosting-Services.aspx[^]

Perhaps this link[^] will help you.

SELECT * FROM mytable AS A
PIVOT (
SUM(AMOUNT)
FOR MEVENT IN([ReliefFund], [Donation], [Festival])
) AS M

See the link in this post[^]

Then try using UNION Query like

SELECT A.NUM, SUM(A.TOTAL) AS TOTAL FROM (
SELECT num1 AS NUM,count(*) AS TOTAL FROM NumaraBilgileri
GROUP BY num1
UNION ALL
SELECT num2 AS NUM,count(*) AS TOTAL FROM NumaraBilgileri
GROUP BY num2
) AS A
GROUP BY A.NUM

You need to create union for all fields.

Are you looking for something like this

SELECT

CASE WHEN NUM1 = 10 THEN 1 ELSE 0 END +
CASE WHEN NUM2 = 10 THEN 1 ELSE 0 END +
CASE WHEN NUM3 = 10 THEN 1 ELSE 0 END +
CASE WHEN NUM4 = 10 THEN 1 ELSE 0 END +
CASE WHEN NUM5 = 10 THEN 1 ELSE 0 END +
CASE WHEN NUM6 = 10 THEN 1 ELSE 0 END
AS TOTAL

FROM MYTABLE

Rajesh Puli wrote:

In this case there is no chance for Programmers

I agree

Well that was not my intention. Yes, some of my clients are still using good old VB6 application. And I told them I will not be able to give any more functionality in this application platform, I can give you support up to some minor changes. I think there is no point of doing any further development on VB6. And that’s why I said so. And I also I gave OP the some solution also. I just didn’t reply OP to say that.

mabrahao wrote:

app on vb6

VB6 is dead.

mabrahao wrote:

how can i know if the transaction is "open" or not.

As much as i can remember (asuming that you are using ADODB) the only way to use a variable. After opening the transaction make it true and after commit or rollback make it false.

vishnukamath wrote:

Im Using The Select Query to Get the data in to datatable

Post the code you are using

vishnukamath wrote:

I Tried A lot Of Ways For Solving This Problem.

Have you tried

cmd.CommandTimeout = 10000;

You mean oracle Substr[^] function

You may use 1. information_schema.columns for columns 2. information_schema.tables for tables 3. sp_helptext 'sp_procedurename' for SP Text

One LIKE operation may help you to compare two image field. Here [^] is a link on Brief Tutorial on Text, Ntext, and Image. You will also find a example how to compare two image column