Search results for query: *

I wrote the following stored procedure to read the last transaction number and added +1 as my new transaction no. Thanks for everyone trying to help me ALTER PROCEDURE [dbo].[SP_NEWTRANNO] @INVH_TXN_CODE VARCHAR(12), @INVH_DT DATE, @INVH_CAL_PERIOD Int, @INVH_NO Int, /*** INVH_NO parameter...

I have details view with colum INVH_NO, INVH_TXN_TYPE, INVH_CUST_CODE, INVH_DT. I want to update INVH_NO as the Last No+1 as new number as per INVH_TYPE when inserting new record; When I went some forums i read suggestions as write procedure ;which i understand like this ; not sure it is...

Dear menthos, You are right. Thank you. Now it is working.

Please advise please advise where is the mistake?????? ; the error is where condition !!!! please advise me how i can build where condition to check the current record is posted(approved) status or not?

Dear All, From the below update command I want to achieve that records will be updated only if field VH_FUEL_Approaval is not clicked. I mean only status of unposted now needs to be updated; The field VH_FUEL_APPROVAL is binded in DetailView as check box. Now select,insert and update all are...

Yes I solved this problem: in iis server the default page was login.aspx ; so initialy it is directed to login.aspx after validation again it is directed to login.aspx as a caller; it is just a loop; instead of login.aspx I set default.aspx as default page in IIS; it was returned to this page...

Dear sir, I sucessfuly tested/debugged login page and it is directing to the page which is defined as start page(Students_add_1.aspx) in visual web developer 2008 express. But when testing it through IIS server that is http://localhost/westernsite the login id/name got validated but not...