Scott,
I have done a fair amount of work with Rbase and MAS90. Unfortunately,
I do not have a lot of good news for you.
First, the MAS90 (Performix) ODBC driver that comes standard with MAS90 is a read only driver. It will not allow updates. I looked into getting
a read/write enabled driver at one point, but they would not sell it, giving the
reason that they could not control data accuracy if outside parties were allowed
write access. (A valid concern, but still frustrating!) It was not so much that another program would corrupt the data records, but that the data control would
be lost. I.E. A person might change the value in a sales order, but not update a Year to Date table, invoice table etc. MAS90 has a huge number of tables that constantly get updated from one transaction and keeping all in sync is the concern.
The second and (main reason for the above) is that MAS90 is not a true relational database. Much of their front end still uses older style record linking.
I.E. In some tables, each record has a field "Previous Record Row" and "Next Record Row". MAS90 programs actually use these fields to parse data. It appears that MAS90 programming has not all been moved over to SQL standards. Parts are SQL based and parts are not.
So, in all my experiences, all I could do was read data (and that was a trick at times due to the above record scheme)and then use Rbase tables for new data or modifications. I could link Crystal reports to both MAS90 and Rbase to get some joined data for reporting, but could never perform updates in MAS90.
Note that this is not an Rbase issue at all, but all due to restrictions placed by BEST Software (MAS90)
Sorry I could not be more encouraging, but if you have other questions let me know.
-Bob
-------------- Original message --------------
> Has anyone in the R:Base community connected to the popular MAS200 or MAS90
> accounting system through ODBC and updated records with R:Base? My goal is
> to use R:Base to maintain a customer database and update changes to more
> than one foreign database. The people from MAS have bragged about their
> product being ODBC compliant. I can view data in their vcustomer table but
> it gives me errors when I try to change and address from within
> R:base. Can someone be truely ODBC compliant and not allow updates to
> their database? I'm turning to the awesome power of the R:base community
> for help.
>
> (The MAS DNS driver is "SOTAMAS90" with the version 3.33.10.00)
>
> Many Thanks,
>
> Scott Stanfield
> Director of Information Technology
> Ohio Ready Mix Inc.
>
