SmartQuant Discussion
http://www.smartquant.com/forums/

BugReports of Multileg Instrument: Table name = LEG_FIELDS
http://www.smartquant.com/forums/viewtopic.php?f=59&t=10541
Page 1 of 1

Author:  loobins [ Tue Jul 02, 2013 5:25 am ]
Post subject:  BugReports of Multileg Instrument: Table name = LEG_FIELDS

Exception "The column cannot contain null values. [ Column name = ID_,Table name = LEG_FIELDS ]" was raised when I modify some property of an Multileg Instrument which was imported from an provider.

Author:  Alexei Kurov [ Tue Jul 02, 2013 5:38 pm ]
Post subject:  Re: BugReports of Multileg Instrument: Table name = LEG_FIE

Hi,

OpenQuant instrument does not contain properties are related to legs.
Which property did you modify?

Author:  loobins [ Wed Jul 03, 2013 4:56 am ]
Post subject:  Re: BugReports of Multileg Instrument: Table name = LEG_FIE

I Found the root cause this issue:

The Column [ID_] of table [LEG_FIELDS] missing “IDENTITY” constraint.

CREATE TABLE [LEG_FIELDS]
(
[ID_] INT NOT NULL IDENTITY (1,1),
[InnerID_] INT NOT NULL,
[OuterID_] INT NOT NULL,
[Type_] INT NOT NULL,
[Tag_] INT NOT NULL,
[Value_] NVARCHAR(255) NOT NULL
);

Author:  Alexei Kurov [ Wed Jul 03, 2013 3:40 pm ]
Post subject:  Re: BugReports of Multileg Instrument: Table name = LEG_FIE

Thank you for the point

Page 1 of 1 All times are UTC + 3 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/