by Frédéric Lamain | Apr 24, 2024 | Non classé
If you want to use interface Excel to import data, you need to make changes in windows. Follow the next steps 1. Login to the server as a administrator.2. Go to “Start” -> “Run” and enter “taskmgr”3. Go to the process tab in task...
by Frédéric Lamain | Jan 2, 2024 | Non classé
Declare @DBId int = 34 Delete from [Address] where [DBId] = @DBId;Delete from [Article] where [DBId] = @DBId;Delete from [ArticlePrice] where [DBId] = @DBId;Delete from [ArticleSupplier] where [DBId] = @DBId;Delete from [ArticleType] where [DBId] = @DBId;Delete from...
by Frédéric Lamain | Dec 18, 2022 | Interface
In this section, you will find all the files necessary to use the Generic Interface Excel. All downloaded zip files contain an Excel file and an XML file used as parameters in the interface. Client invoice Company Contract Contract claim Contract detail Contract...
by Frédéric Lamain | Jul 13, 2022 | Query
Select distinct [BlacklistedAlias].[FirstName] + ‘ ‘ + [BlacklistedAlias].[LastName]From [BlacklistedAlias] Inner Join [Blacklisted] On [BlacklistedAlias].[BlacklistedId] = [Blacklisted].[Id]Where [Blacklisted].[TableNumber] = 17 And...
by Frédéric Lamain | Jun 28, 2022 | Query
Select [GLAccountCur].[DBId], [GLAccount].[Number], [GLAccountCur].[GLAccountId], [GLAccountCur].[CurrencyId], [GLAccountCur].[Amount], [ResGLYEBalance].[StartBalance] from ([GLAccountCur] LEFT JOIN (Select [GLYEBalance].[DBId], [GLYEBalance].[GLAccountId],...