Is it possible that in IMan the fields are text but in SQL they are numeric (or vice versa)?
Mary, thanks - this would be my first check.
If your fields are all setup as text, then they will sort as text.
Change the field types to either Integer or Decimal if you want to sort numericallty.
Hello all,
I just wanted to send a message that I have matched up the data types but still getting the strange result. Any additional things I should look into?
Thanks
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 everyone. I've run into a bit of a problem that I was hoping you could help me with.
I have an Iman Job that uses a sort transform to assign three sorting keys but when I compare that to the list I've sorted with the same three identifiers in SQL the lists do not match up. Why is that? I noticed in the XML (Job Config)there are sorting directions applied to some of the elements (but they have no key) Are those factored into sorting at all?
Hopefully someone can help me shed some light on how this sorting is working behind the scenes. Thanks for checking this post out.