Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Negative value are redueced by 0.01 while updation from VFP
Message
De
23/04/2000 07:08:12
 
 
À
Tous
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
Divers
Thread ID:
00362568
Message ID:
00362568
Vues:
45
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
Fil
Voir

Click here to load this message in the networking platform