General information
Forum:
Microsoft SQL Server
Title:
Negative value are redueced by 0.01 while updation from VFP
I have noticed a strange behaviour when the views are updated from vfp
the negative values are changed by 0.01 every time and the postive values remain same. I use negative values for debit amounts.
The script for the table in SQL is
---------------------------------------------------------------------
/****** Object: Table dbo.genled Script Date: 4/23/00 5:15:06 PM ******/
if exists (select * from sysobjects where id = object_id('dbo.genled') and sysstat & 0xf = 3)
drop table dbo.genled
GO
/****** Object: Table dbo.genled Script Date: 4/23/00 5:15:06 PM ******/
CREATE TABLE dbo.genled (
glcd char (10) NOT NULL ,
gldt datetime NOT NULL ,
glfl char (8) NOT NULL ,
glblno char (10) NOT NULL ,
glblsrno char (5) NOT NULL ,
glamnt numeric(18, 2) NOT NULL ,
gltrcd char (10) NULL ,
matched numeric(18, 2) NULL ,
balance numeric(18, 2) NULL ,
glnarr varchar (255) NULL
)
GO
---------------------------------------------------------------------
Where am I going wrong
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only