Thanks for your help, but I'm not sure to understand what you mean with the user
highlighter for PHP files and CodeFolding (Code Explorer is working, only
CodeFolding not)
I've created a user highligter for PHP files, with option cftCurlyBracke, but
can't see any difference.
BTW sent you the french translation updated.
Here is an example of SQL code not correctly working with the CodeFolding
feature:
CREATE TABLE dbo.IMG(
IDIMG numeric(15, 0) IDENTITY(1,1) NOT NULL,
IDINTER numeric(15, 0) NOT NULL,
IMGLINK nvarchar(255) NULL,
IMGCATEGORY nvarchar(3) NULL,
IMGTYPE nvarchar(35) NULL,
IMGFORMAT nvarchar(4) NULL,
IMGDATETIME nvarchar(14) NULL,
IMGBUINTDATETIME nvarchar(14) NULL,
VERSION datetime NOT NULL,
PRIMARY KEY (IDIMG),
FOREIGN KEY (IDINTER) REFERENCES dbo.INTER(IDINTER)
);
CREATE PROCEDURE [dbo].[Notify_Report_Error]
@day varchar(10) -- example 2014-12-01
AS
BEGIN
SET NOCOUNT ON;
SELECT COALESCE(f.creator,'unknown'),
COALESCE(e.delisusr,'unknown'),
( SELECT resource FROM tfile where idproc = f.idproc AND split = 0)
resource,
CASE WHEN f.ifgroup = 'MPSEXPDATA' THEN COALESCE(f.ifgroup,'') + '_'
+ COALESCE(f.ifvers,'')
ELSE COALESCE(f.ifgroup,'') + '_' + COALESCE(f.ifclass,'') + '_' +
COALESCE(f.ifvers,'') END,
f.encoding,
COALESCE( ( SELECT s.mpsid FROM tsync s WHERE s.idshipment =
e.idshipment),'') mpsid,
e.errclass,
COALESCE(e.errtype,''),
CASE WHEN f.split = 0 THEN COALESCE(e.errfield,'') + ' (line ' +
CASE WHEN e.line > 0 THEN CONVERT(VARCHAR(8), e.line) ELSE '-' END
+ ')'
ELSE COALESCE(e.errfield,'') END,
COALESCE(e.errvalue,''),
e.idshipment, e.version
FROM verror e, tfile f
WHERE e.idfile = f.idfile
AND ( f.creator <> 'DERRICK' OR f.creator IS NULL )
AND ( e.errclass IN (3,4,5) OR e.errfield = 'SKIP_DATA' )
AND DATEDIFF(dd, @day, f.version)=0
--limitation
ORDER BY f.creator, f.idfile DESC
END
/****** Object: StoredProcedure [dbo].[Notify_Report_Shipments] Script Date:
12/10/2014 16:08:33 ******/
SET ANSI_NULLS ON
GO
/****** Object: StoredProcedure [dbo].[Notify_Report_Error_BI] Script Date:
21.10.2020 15:03:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--
<https://forum.pspad.com/read.php?4,76266,76268>
PSPad freeware editor https://www.pspad.com
