Please disregard. I have used a method where I mark the records as processed rather than delete them.
Thanks.
Mark, just to let you that there is a bug here, but two easy workarounds:
Change from:
delete from Customers
To
delete from Customers;
select "1" as "FakeID"
Thank you! This worked nicely.
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Hello,
Prior to upgrading to v5.0, I was able to issue a DELETE to clear a SQL table's records. Using a Database Read Reader, my SQL statement was:
Delete
FROM dbo.ARInvoiceUpload
However, with v5.0 I get "Object reference not set to an instance of an object." error.
Is there a different, legal way to accomlish deleting all records from a temp table?
Thank you.