Devart Forums

Code: Select all

CREATE TABLE [dbo].[PrintInfo](
	[ID] [uniqueidentifier] NOT NULL,
	[FirmID] [int] NOT NULL,
	[FirstInvoiceID] [int] NULL,
	[AddDate] [datetime] NOT NULL,
	[Attributes] [int] NOT NULL,
 CONSTRAINT [PK_PrintInfo] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PrintInfo] ADD  CONSTRAINT [DF_PrintInfo_ID]  DEFAULT (newsequentialid()) FOR [ID]

Code: Select all

select Payments.PayID, Payments.UserID, Payments.PayDate, Payments.PayTypeID, Payments.AddPayDate, PL.Attributes PLAttributes, 
(SELECT dbo.Concatenate(S.PayServiceID) FROM PayedServices S (NOLOCK) WHERE S.FirmID=Payments.UserID AND S.PayID=Payments.PayID) AS PayedServicesStr, 
PT.Attributes AS PTAttributes 
FROM payments Payments (NOLOCK) 
LEFT JOIN PayPlaces PL (NOLOCK) ON PL.PayPlaceID=Payments.PayPlaceID 
LEFT JOIN InvoicePayTypes PT (NOLOCK) ON PT.PayTypeID=Payments.PayTypeID 
WHERE Payments.UserID=100 AND ISNULL(Payments.Attributes,0)&2!=2 
AND dbo.sf_IsNonPeriodServices(Payments.UserID, NULL, Payments.PayID)=0 
ORDER BY Payments.PayDate, Payments.PayID

Code: Select all

CREATE TABLE [mb_suprt](
	[MsgID] [int] NOT NULL,
	[Subject] [nvarchar](250) NULL,
	[Message] [nvarchar](max) NULL,
	[SeqID] [uniqueidentifier] NOT NULL,
 CONSTRAINT [PK_mb_suprt] PRIMARY KEY CLUSTERED 
(
	[MsgID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [mb_suprt] ADD  CONSTRAINT [DF_mb_suprt_SeqID]  DEFAULT (newsequentialid()) FOR [SeqID]

Code: Select all

 Q.SQL.Text:='SELECT * FROM mb_suprt WHERE MsgID='+MsgID;
 Q.UpdatingTable:=mb_suprt;
 Q.KeyFields:='MsgID';
 Q.Open;
 [b]Q.Insert;[/b] // this row raises exception
...