0

hi,
how to auto increment the value in database table when the button clicks.i have created a table named register .when the user completes his registration we will generate the receipt based on the registration. so for every receipt we will generate the receipt no on that. when we click on receipt button,give the receipt ,it contains name,date,registration no. , amount,receipt no. .so we have to generate these fields as receipt.. so can u tell me solution for that..

2
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by mohankumar554
0

hi,
thanks for ur reply.. but i need to print the receipt with the receipt no. and along with the register fields. can i write the query like this..
insert into receipt(applicationno,name,date)values (select applicationno,name,date from register);
is it right or not.plz tell me..

0

hi..
it gives the error "Column names in each table must be unique. Column name 'receiptno' in table 'receipt' is specified more than once." so how can i overcome this error.. plz tell me the solution.thanks.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.