Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Negative value are redueced by 0.01 while updation from VFP
Message
From
23/04/2000 07:08:12
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Negative value are redueced by 0.01 while updation from VFP
Miscellaneous
Thread ID:
00362568
Message ID:
00362568
Views:
46
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
Map
View

Click here to load this message in the networking platform