Sunday, February 5, 2012

How to write sage line 50 database SQL query?

It's been a while since I did it, but the last time I needed to query Sage directly I used MS Query (you can go via MS Access or MS Excel). If you're using a more sophisticated language then Sage will also expose an ODBC interface that you can use to pass SQL/data.



MS Query will also show you the table structure (but not the relationships if I recall). Aside from that it seems to be capable of standard SQL (not sure what engine it uses though, so you might have trouble with some of the more esoteric stuff).

flip flop

No comments:

Post a Comment