A set of technologies in the .NET Framework for building web applications and XML web services.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
In my Asp.net+VB+SQL database website. I have a table named Clinic_Medicine
USE [FTH_BLR] GO /****** Object: Table [dbo].[Clinic_Medicine] Script Date: 3/2/2023 11:18:46 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Clinic_Medicine]( [Med_ID] [int] IDENTITY(1,1) NOT NULL, [Medicine] [varchar](max) NULL, [Type] [varchar](50) NULL, [BatchNo] [varchar](50) NULL, [Exp_dt] [datetime] NULL, [Qty] [varchar](50) NULL, [Purchase_Date] [datetime] NULL, [Vendor] [varchar](max) NULL, [Remarks] [varchar](max) NULL, [Operator] [varchar](50) NULL, [Eff_Date] [datetime] NULL, CONSTRAINT [PK_Clinic_Medicine] PRIMARY KEY CLUSTERED ( [Med_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO
i have a code to add new medicines into DB as under
sql_ins = "Insert into Clinic_Medicine (Medicine, Type, BatchNo, Exp_dt, Qty,Purchase_Date,Vendor,Remarks,Operator,Eff_Date) values (@a,@aa,@b,@c,@d,@e,@f,@g,@h,@i)"
this code stores the data in my SQL DB
I have code to add medicine into my DB and its works fine for me. Data is stored correctly in DB
now i have multiple rows for same medicine in DB
but while issuing the data . issue is happening from oldest stock and even though teh stock is 0 its still issuing from that row and it gets in to minus
Hi @Baiju EP,
According to your description, I understand that this problem is the problem of warehouse inbound and outbound. Do you mean that when the stock is 0, it can still achieve the outbound operation, so that the actual data is wrong? If this is the case, I think you have to check the relevant logic code and check whether the current stock allows the outbound operation before the outbound. You can also post some relevant code so that we can better locate the problem.
But if I misunderstand anything, please let me know.