views:

227

answers:

2

Hi, I am accessing Sage 50 data via their ODBC Driver but cannot seem to establish if the tables have a unique / primary key. The ODBC.NET Driver does not seem to return any information relating to indexes or key field information.

Anyone got any clues?

Tim

A: 

Tables ending in "m" seem to be master tables with actual real data in...

Don't know if that helps at all.

Jonathan
A: 

Sage Line 50 uses a proprietry database. As far as I am aware there is no indexing of the tables.

Please contact me if you want further information or are intrerested in our Sage reporting tool.

Jason Raikes

[email protected]

www.pendragonsystems.com

Jason Raikes