Posts by debasisdas

I would suggest 3rd way (some changes to method 1).

844

848

852

and West Indies is going back to home.

852

lets see your code.

and what exactly is the error message ?

try this sample

select count(*) from demo where user_name = u_name and password = pwd

if this SQL returns 1 log in successful and proceed further
else
re-prompt for username / password.

No need of any looping or checking for EOF.

No assignments please.

We don't spoon feed here.

One team will be out of race today.

852

848

@Momerath

Don't post today , will feel ever better ;)

828

Good morning.

786

good night ...

630

EOD

6.2.8

better take rest guys

628

626

6/2/6

..624

6 2 4

624

6_2_4

6.2.2

622

6.2.0

620

6 2 0

620

6_2_0

6 2 0

618

618

Hi.
i detached the database and added it to my program as an existing item

What exactly you did ?

614

Use must use a dot matrix printer.

614

Kids must go to bed early.:zzz:

6 1 4

614

618

618

616

It's hard to wait for something you know might never happen.
But it's even harder to give up when you know it's everything you want.

Everything always works in development system.

Ensure that you are passing the proper file name.

Lets know first how you have connected / calling CR from your apps.

i want to delete a record by searching that number in two tables Table1 and Table2,the record may present in Table1 or Table2 ,so it should check both the Tables ,if it is found in table1 it should delete or else from table 2 it should delete.

As you say, you are not sure the record exists in which table. At least you should know the value is expected in which column of the table. And since the tables are independent of each other, you can run DELETE on the individual tables no need to search. When you execute DELETE the record will be deleted it exists else not.

... you can vote as you please

What the hell, how can he vote, is till a minor. :twisted:

I visited this thread several times in last couple of days, but never had the patience to read 600 + lines of code.

May be i will visit this again in the weekend.

I want to add a column that shows the number of cupcakes the customer bought for that specific order_date

I assume you are trying to add that column in SQL output, not in the actual table.

Kindly post your table structure and relation between them.

Do you have the under lying database in place ?