MAS 90 version = 4.30.0.23 ProvideX driver version = 4.21.1000 I am attempting to query MAS 90 data using the ProvideX ODCB driver. My queries are running, but no data is returned.
1) MAS 90 has been set up with a role that gives me read access to all…
I'm doing a Pass Through Query using Microsoft Access, the SQL statement below works fast and fine.
Is there a way to request the date parameters from the user in the WHERE statement each time the query is run instead of the parameters being hard coded…
We have Sage 100 Advanced (MAS200).
Sage 100 Premium has a sql database. My very general question is "why would someone choose Premium over Advanced?
What advantages does have Sql provide over not having sql. Aside from reporting speed, does it offer…
We have Sage 100 (MAS200) with providex database. We are thinking of getting a sql based version of Sage whether than be 100 or 500.
My question is very general. It is generally accepted that having an "open database" is superior to a Proprietary. Am…
We are currently using Sage 100 and want to move away from a proprietary database. We were looking into Sage 500. In all my researching someone just mentioned to me that Sage 500 has been classified as a ‘sunset’ product meaning… while companies can still…
Hello,
I am new to the world of Sage ERP.
I have designed this query and it works fine in SQL:
SELECT o1.*, ( Select isnull(SUM(D002_DollarsRented)+SUM(DollarsSold),0) FROM openquery(TESTSWRMAS, 'select * from AR_CustomerSalesHistory') o2 WHERE…
