debasisdas 580 Posting Genius Featured Poster

166

debasisdas 580 Posting Genius Featured Poster

174

debasisdas 580 Posting Genius Featured Poster

178

debasisdas 580 Posting Genius Featured Poster

178

debasisdas 580 Posting Genius Featured Poster

180

debasisdas 580 Posting Genius Featured Poster

184

debasisdas 580 Posting Genius Featured Poster

186.

debasisdas 580 Posting Genius Featured Poster

186

debasisdas 580 Posting Genius Featured Poster

190

debasisdas 580 Posting Genius Featured Poster

194

debasisdas 580 Posting Genius Featured Poster

198

debasisdas 580 Posting Genius Featured Poster

200

debasisdas 580 Posting Genius Featured Poster

It is really difficult to guess what is happening in your system blindly.

debasisdas 580 Posting Genius Featured Poster

204

debasisdas 580 Posting Genius Featured Poster

208

debasisdas 580 Posting Genius Featured Poster

212.

debasisdas 580 Posting Genius Featured Poster

212

debasisdas 580 Posting Genius Featured Poster

214

debasisdas 580 Posting Genius Featured Poster

212

debasisdas 580 Posting Genius Featured Poster

214

debasisdas 580 Posting Genius Featured Poster

214.

debasisdas 580 Posting Genius Featured Poster

212

debasisdas 580 Posting Genius Featured Poster

Using which database ?

How you connect to database ?

If using ADO, status property of connection object is what you are looking for.

debasisdas 580 Posting Genius Featured Poster

208.

debasisdas 580 Posting Genius Featured Poster

208

debasisdas 580 Posting Genius Featured Poster

206.

debasisdas 580 Posting Genius Featured Poster

206

debasisdas 580 Posting Genius Featured Poster

166

debasisdas 580 Posting Genius Featured Poster

170

debasisdas 580 Posting Genius Featured Poster

You need not do that using SQL.

That is a standard feature in any reporting tool.

debasisdas 580 Posting Genius Featured Poster

176

debasisdas 580 Posting Genius Featured Poster

Hi Paul,

Welcome to Daniweb.

Your name suggests you are so wise :)

debasisdas 580 Posting Genius Featured Poster

180

debasisdas 580 Posting Genius Featured Poster

The reporting tool will handle the 2nd part of your question.

debasisdas 580 Posting Genius Featured Poster

182

debasisdas 580 Posting Genius Featured Poster

186

debasisdas 580 Posting Genius Featured Poster

190

debasisdas 580 Posting Genius Featured Poster

try this

select * from table where upper(animal) = upper('horSe')

even better to use LIKE for pattern matching.

debasisdas 580 Posting Genius Featured Poster

194

debasisdas 580 Posting Genius Featured Poster

196

debasisdas 580 Posting Genius Featured Poster

after sometime you will feel the heat :twisted:

debasisdas 580 Posting Genius Featured Poster

196

a loooooooooooong way to before i sleep.

debasisdas 580 Posting Genius Featured Poster

200

debasisdas 580 Posting Genius Featured Poster

204

debasisdas 580 Posting Genius Featured Poster

208

debasisdas 580 Posting Genius Featured Poster

Are you trying to create a report out of this query ?

debasisdas 580 Posting Genius Featured Poster

212

debasisdas 580 Posting Genius Featured Poster

218

debasisdas 580 Posting Genius Featured Poster

You need to set the network path instead of local path in the database connection string.

debasisdas 580 Posting Genius Featured Poster

If you have INTEGRITY, nothing else matters. If you don't have integrity, nothing else matters.---- Alan Simpson.