Sage ODBC Deleted Records

You are here:

Home
Development
Sage ODBC Deleted Records

January 14, 2016 Leave a commentDevelopmentBy Jamie Watson

We have recently been doing some work on integrating our Sage Line 50 with some internal systems, I had a problem where item lines on purchase orders, invoices / quotes would still be returned via ODBC even though they had been deleted in Sage. This is a bug in ODBC and can only be solved by compressing your sage data. There is a field RECORD_DELETED on most tables and this does even seem to flag, so unfortunately it’s impossible to distinguish from the rows that are returned via ODBC which items have been deleted. We can only hope that Sage will fix this in a later release?

About the author

Jamie Watson

I started my career as most people do – at the bottom. After leaving college I went straight into an IT position at a Huddersfield based Chartered Accountants. It wasn’t long before they expanded overseas, giving me the perfect opportunity to develop my career. Whilst there, I also completed a computing qualification at the University of Leeds and polished my skills in Microsoft, Cisco, Lotus, Checkpoint, Citrix, A+ and Novell.