Sage ODBC Deleted Records

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?

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.

Fusion release IDCheck
September 15, 2020

eSign now with multiple signatures
September 7, 2020

Integrations: It’s a growing connected world
August 21, 2020

Parse JSON Data with OPENJSON in SQL Server
June 27, 2020

Restoring Power BI Server Files
June 10, 2020

Working hours between two datetime TSQL
June 9, 2020