+44 (0)1273 013695
Join a Support SessionSelecting details of Configurators from QuoteWerks database
Jan 11, 2019
The below T-SQL statement provides a template for selecting details of Configurators and their associated Containers and Items from the QuoteWerks SQL Server database. If you have any questions or if you’d like an equivalent for an Access backend, then please email development@hilltopsit.co.uk. SELECT CH.Name AS ConfiguratorName, CH.Notes AS ConfiguratorNotes , CC.Name AS ContainerName , […]
READ MORESelecting details of Substitute Items from QuoteWerks database
Jan 11, 2019
The below T-SQL statement provides a template for selecting details of Substitute Items from the QuoteWerks SQL Server database. If you have any questions or if you’d like an equivalent for an Access backend, then please email development@hilltopsit.co.uk. SELECT SH.SetName AS SubstituteSetName, SH.[Description] AS SubstituteSetDescription , SI.PartNumber AS SubstituteProductCode, PO.[Description] AS SubstituteProductDescription FROM QuoteWerks.dbo.SubstitutionHeaders AS […]
READ MORESelecting details of Required Items from QuoteWerks database
Jan 11, 2019
The below T-SQL statement provides a template for selecting details of Required Items from the QuoteWerks SQL Server database. If you have any questions or if you’d like an equivalent for an Access backend, then please email development@hilltopsit.co.uk. SELECT RH.PartNumber AS PrimaryProductCode, PP.[Description] AS PrimaryProductDescription , RI.PartNumber AS RequiredProductCode, PO.[Description] AS RequiredProductDescription FROM QuoteWerks.dbo.RequiredHeaders AS […]
READ MORESelecting details of Optional Items from QuoteWerks database
Jan 11, 2019
The below T-SQL statement provides a template for selecting details of Optional Items from the QuoteWerks SQL Server database. If you have any questions or if you’d like an equivalent for an Access backend, then please email development@hilltopsit.co.uk. SELECT OH.SetName AS PrimaryProductCode, PP.[Description] AS PrimaryProductDescription , OI.PartNumber AS OptionalProductCode, PO.[Description] AS OptionalProductDescription FROM QuoteWerks.dbo.OptionsHeaders AS […]
READ MOREQuerying the QuoteWerks Database for selected Line Items
Jan 11, 2019
In our years of working with QuoteWerks and providing integration solutions, it’s been a fairly common requirement to query the QuoteWerks database for Line Items on a Document which are either non-optional or optional and selected. How to do this relies on understanding the bitwise logic around the Document Items table LineAttributes field. More information […]
READ MORE‘Allow log on through Terminal Services Right’ error message
Sep 23, 2010
Complete error message: “To log on to this remote computer, you must be granted the Allow log on through Terminal Services right. By default, members of the Remote Destop Users group have this right. If you are not a member of the Remote Desktop Users group or another group that has this right, or if […]
READ MORE