This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
hello I am developing banking application MS--Access as back end for my account no. field i have to run a query in to table of access for getting the last account so the program may start from the next one but i am enable to do so can any one please help me note once again i have to select table in to which account no is a record set and from that set i have to select the last one then save that no into a integer of String type in code thanks in advance dhiraj
Hey Dhiraj, If u r database is having the account_no as integer and u need to take the last account no then do this query select max(account_no) from table no.. then increase the no by one and then store it in string.. Hope this is what u want..... Regards Venugopal Askani
Joined: Aug 29, 2001
Thanks Mr. Venugopal Ur solutions works but i still have one problem when i register only one and close the problem it's ok but when in continuty account no. remains same can u please help me Thanks again Dhiraj