1.1.x.19

updated libs

1.1.x.18

added "patientstreatmentsTitle" to DentneDPrintModelDefault.json

1.1.x.16

/*
UPDATE DB script.

Run this script on to update all the TEXT column type to VARCHAR(MAX)
You are recommended to back up your database before running this script
*/

SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
GO
IF @@error <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[reports]'
GO
IF @@error <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[reports] ALTER COLUMN [reports_query] [varchar] (max) COLLATE Latin1_General_CI_AS NOT NULL
ALTER TABLE [dbo].[reports] ALTER COLUMN [reports_infotext] [varchar] (max) COLLATE Latin1_General_CI_AS NULL
GO
IF @@error <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[treatments]'
GO
IF @@error <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[treatments] ALTER COLUMN [treatments_notes] [varchar] (max) COLLATE Latin1_General_CI_AS NULL
GO
IF @@error <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[patientstreatments]'
GO
IF @@error <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[patientstreatments] ALTER COLUMN [patientstreatments_notes] [varchar] (max) COLLATE Latin1_General_CI_AS NULL
GO
IF @@error <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[appointments]'
GO
IF @@error <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[appointments] ALTER COLUMN [appointments_notes] [varchar] (max) COLLATE Latin1_General_CI_AS NULL
GO
IF @@error <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[patients]'
GO
IF @@error <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[patients] ALTER COLUMN [patients_notes] [varchar] (max) COLLATE Latin1_General_CI_AS NULL
GO
IF @@error <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[patientsattachments]'
GO
IF @@error <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[patientsattachments] ALTER COLUMN [patientsattachments_note] [varchar] (max) COLLATE Latin1_General_CI_AS NULL
GO
IF @@error <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[patientsattributes]'
GO
IF @@error <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[patientsattributes] ALTER COLUMN [patientsattributes_note] [varchar] (max) COLLATE Latin1_General_CI_AS NULL
GO
IF @@error <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[patientscontacts]'
GO
IF @@error <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[patientscontacts] ALTER COLUMN [patientscontacts_note] [varchar] (max) COLLATE Latin1_General_CI_AS NULL
GO
IF @@error <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[patientsmedicalrecords]'
GO
IF @@error <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[patientsmedicalrecords] ALTER COLUMN [patientsmedicalrecords_note] [varchar] (max) COLLATE Latin1_General_CI_AS NULL
GO
IF @@error <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[patientsnotes]'
GO
IF @@error <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[patientsnotes] ALTER COLUMN [patientsnotes_text] [varchar] (max) COLLATE Latin1_General_CI_AS NOT NULL
GO
IF @@error <> 0 SET NOEXEC ON
GO
PRINT N'Altering [dbo].[payments]'
GO
IF @@error <> 0 SET NOEXEC ON
GO
ALTER TABLE [dbo].[payments] ALTER COLUMN [payments_notes] [varchar] (max) COLLATE Latin1_General_CI_AS NULL
GO
IF @@error <> 0 SET NOEXEC ON
GO
COMMIT TRANSACTION
GO
IF @@error <> 0 SET NOEXEC ON
GO
DECLARE @success AS BIT
SET @success = 1
SET NOEXEC OFF
IF (@success = 1) PRINT 'The database update succeeded'
ELSE BEGIN
IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION
PRINT 'The database update failed'
END
GO

1.1.x.15

updated to 4.6.2, updated version

1.1.x.14

updated libraries and version

1.1.x.13

updated libraries and version

1.1.x.12

updated AdvancedDataGridView, added translations for AdvancedDataGrid…

1.1.x.11

updated DGUIGHF, added Fit All forms

1.1.x.10

rebuilt