Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement