Posts by debasisdas

822

822

bad habbit

What about using a grid instead.

822

826

try this

If dr(DbaseExpiryDate) > Format(Now, "MM/DD/YYYYyyyy") Then

What do you mean by still ?

830

yet to have breakfast.

You need to go through this.

go through the links , try to understand the code and then comeback with the code that you are working on. Our experts are always there to lend a helping hand.

My suggestion was to use a couple of Grid controls rather than List views.

834

Good Afternoon royng.

why you need a separate table for father, mother, sibling.

Are not they citizens ?

You need to store the info of all the citizen in a single table and then map the data to proper column.

838

Good morning all.

10:00 am --in my time zone.

Happy to learn your issue is solved.

Happy coding. :)

The root cause is the string function LEFT in your code.

and if CensusBlockID is a character field it will be even more time consuming.

Otherwise using JOIN in place of sub query is good option.

Is it because of the single quote.

Just frame and print the query before executing, it will be easy to trace the error.

Happy to learn that your problem is sorted out.

Happy Coding :)

842

Nice to know your issue is sorted out.

Happy coding :)

I don't think this is purely MS SQL code.

Why not use a grid for the purpose.

842

842

If decrypting cipher was so easy anyone would have done that.

Basically CIPHER is an algorithm, and to break that you need to understand the same and find a reverse algorithm .

And what about do your own assignment by yourself.

1. You need to pass more information.
2. Yes.

846

850

852

So you mean to say what ever you enter in text boxes needs to be added into list view, right ?

and i think after 80 posts, you should understand that you need to show some effort to get any help here.

848

why not use

Select (*) FROM student

that will give the count and is much faster, even better if you count particular indexed column.

842

844

You do not know the difference between VB 6 and dot net code and claim this code is yours.

@Debasidas, its the code of AndreRet man!

Now see the attitude.

846

Im using Visual Basic not VB.net. well whats the difference by the way lol?......and already an assignment...

Ohh,

may be i took too long to type the previous post.

and see what the OP has.

he nicely made the expert do his assignment

and the 1st line of code confirms he has copied it from some where is not his own code.

After all these posts, I see you are using vb.net

If one goes through this thread, it is quiet clear that the OP has never said what exactly he has really done. But he always pretended to do a lot while he actually did nothing. Nicely he framed his questions and made our expert do all the coding. Once the code is delivered he comes back complaining that it is not working.

Now the expert realises all his assumption was wrong (OP has posted some code from some where)and the actual coding was to be done in .NET not in VB6.

May be the expert now will start writing code again in .net and supply. But i am sure that will again not work for OP. Because s/he never understood the code (never bothered to do that), it is clear from previous posts.

Pakistan in Semis.

I believe this is the most emphatic win in world cup quarter final and that to over two times champions.

848

848

848

846

844

844

@trilok31

Read line #6 of Jx_Man's code

Which chapter you are talking about ?

are you getting any error with the code ?

check for your DB field type and the data that you are passing in the SQL.

lets see your code that you have so far.

844