SIMS SQL Server Table Documentation

[peterteckhokgoh]

Hi

 

i am looking for any documentation anyone might have (homemade or otherwise) regarding the table structures of SIMS Sql tables. I am doing some ugly hacks into it and this kind of information would be really useful. I would also be interested in anyone else who has gone down this route of integrating data straight from the tables.

 

thanks

 

pete

[Geoff]

Altering the Sims.NET database directly causes your license to explode IIRC. You must use the provided API to interface with Sims.NET and it's database.

[peterteckhokgoh]

I am not altering it, i am merely reading from it. plus i have taken a copy of the mdb and am testing everything on there. this is ok right?

[Geoff]

Nope, you have to use the APIs.

[peterteckhokgoh]

I don't understand. why would it matter if i corrupted a copy of a database? plus there is very little corruption you can do with read only functions.

[Geoff]

Read your EULA for SIMS.Net.

[localzuk]

It is part of the license agreement for SIMS.net that you must use the APIs to access the database. If you don't, you are in breach of the agreement.

 

You have to make use of the commandreporter.exe application and run reports instead.

[peterteckhokgoh]

ok brilliant. thanks very much. will look into this. i assume you don't have any info on table structures though?

 

thanks

 

pete