Iam doing a sales and purchase management proj ...i need to implement a feature in which the stock updates like if it is out of stock it should notify me before a time period like 7 days or so///the front end is vb 6.0 and back end is sql server 2005
kavya_nayak7 0 Newbie Poster
vb5prgrmr 143 Posting Virtuoso
Do you have a table that lists the quantity? If so, you could create and use another table that holds notification info on when user should be notified when the stock is running low... Or for that matter you could append a field to the table... say iReOrdQty and use it to run a query against the iQty field...
strSQL = "SELECT * FROM tblStock WHERE iReOrdQty <= iQty"Good Luck
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.