hi, i have created a drug dispensing client to be used by a pharmacy shop as a project. i need to add a function that can tell whether a drug has expired in the database. Csv was used. any idea how i should go about it. Thanks
mcroni 0 Newbie Poster
Santanu.Das 125 Santanu Das
Hi,
I do not know your database structure and you did not describe it. From the previous experiance I can say you that go through the purchased products table searching by ProductID and BatchNo and check the condition on BatchExpDate for expiary.
Hope it can give you a way.
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.