Thank you peter and Jeff for your articles.  They really are very helpful.  But still I have some problems . Hope you dont mind...

Can we use .net interface for this, instead of trying only with sql statements?  I know even then we need to run sql statements but just thinking that it may...

Thank u david.  Now I changed the enableviewstate property of all controls in that page to true and readonly property of textboxes where we have date to false.  Now it...

Ya I do get rows back when i run the select with same where clause in query analyzer.  txtpno is readonly.  if u say my code is not very secure...

When I run this I got the following result.  What does RunningBalance is Actually representing?

FiFoID      PartNo     RowType Date                        Rate        Quantity    RunningBalance ShortTerm   LongTerm   

----------- ---------- ------- --------------------------- ----------- ----------- --------------...

Thank you very much Jeff.  I will try this.  I hope this works. 

SIMPLE QUESTION: when inventory is received, is the quantity remaining column null, zero or equal to the quantity received?

   When inventory recieved, the quantity remaining column may or may not...

Jeff Thank you.

I used

set language 'us_english'

Now I am not getting the error.  But now facing another problem ofcourse it not related to date format.  This is regarding  update command. 

I...

If I assume it had happened so,  how to find it and correct it.  I am going panic since it is really an urgent work.

Ya, () represents multiplication.

Could you explain why 45 means the value must be (2(20)+2(20-15))... sorry to be thick on this but I don't know enough about what that must be. 

For the...

Ya this is FIFO inventory system.  Recieved and Issue items will be in different table say, RECIEVE  & ISSUE. Each item may be recieved and issued many times.  Each time...

I find difficult where to start from.  I wrote the query to retrieve the first item of each type of partno.  Then dont know how to proceed.

select partno

from receive a

where partno...