by FLO | Dec 11, 2019 | Query
SELECT [RelType].[Label], [RelType].[Type], [InvRelType].[Label] as [InvLabel], [InvRelType].[Type] From ([RelType] left Join [RelType] as InvRelType on ([RelType].[Id] = [InvRelType].[InvRelTypeId] and [InvRelType].[DBId] = @DBIdInvRelType@)) where...
by FLO | Mar 5, 2019 | Non classé
Select * from [GLAccGLCaption] where [GLCaptionPlanId] = 0 Select Top 20 [DBId] from [GLAccGLCaption] where [GLCaptionPlanId] = 0 Group by [DBId] Order by [DBId] Select [GLAccGLCaption].[DBId] as [ResDBId], [GLAccGLCaption].[GLCaptionId] as [ResGLCaptionId],...
by FLO | Mar 1, 2019 | Non classé
In order to use some functionnalities of DeMaSy in VBA module, you can use the DLL DeMaSyNET_COMObject. This dll needs to be placed in the same folder as the other DeMaSy dll ( C:Program Files (x86)Silicon DNADeMaSy ). This DLL is COM Compatible.You can register it on...
by FLO | Jun 26, 2018 | Query
Use this query to select unbalanced accounting entries on all the databases: Select [DBList].[LogicalName], [DBList].[DBId], [GLPeriod].[Name], [GLMovement].[EntryNumber] From ([GLMovement] INNER JOIN [GLPeriod] ON ([GLMovement].[GLPeriodId] = [GLPeriod].[Id] and...
by FLO | Apr 5, 2018 | Non classé
Install SQL Server Install SQL Management Studio Check if TCP/IP is Enabled in SQL Server Configuration Install DeMaSy (Run as Administrator) Set Full Rights to Everyone for the Silicon DNA Folder Initial Install in Utilities (Run as administrator) Check all the...