debasisdas 580 Posting Genius Featured Poster
debasisdas 580 Posting Genius Featured Poster
166
174
178
178
180
184
186.
186
190
194
198
200
It is really difficult to guess what is happening in your system blindly.
204
208
212.
212
214
212
214
214.
212
Using which database ?
How you connect to database ?
If using ADO, status property of connection object is what you are looking for.
208.
208
206.
206
166
170
You need not do that using SQL.
That is a standard feature in any reporting tool.
176
Hi Paul,
Welcome to Daniweb.
Your name suggests you are so wise :)
180
The reporting tool will handle the 2nd part of your question.
182
186
190
try this
select * from table where upper(animal) = upper('horSe')
even better to use LIKE for pattern matching.
194
196
after sometime you will feel the heat :twisted:
196
a loooooooooooong way to before i sleep.
200
204
208
Are you trying to create a report out of this query ?
212
218
You need to set the network path instead of local path in the database connection string.
If you have INTEGRITY, nothing else matters. If you don't have integrity, nothing else matters.---- Alan Simpson.