Error whilst evaluating field - Incorrect syntax (2 replies)
Tj, simply enter an evaluation which evaluates to true in the where clause.
For example 1=1
thank you so much.
Tj, simply enter an evaluation which evaluates to true in the where clause.
For example 1=1
thank you so much.
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
Hi
I have an issue on the new version 4.2 where I get the following error:
Resolved Function - Lookup("RETJOB", "RetrievalStatusID", "", true) Error - Description: ERROR [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'where'.
it seems iman does not like the blank WHERE Clause of SQL but this worked fin version 3.x.x
Can you please advise.