Hi Guys:
When I changed one word in my SQL sction , I got different results in the report! Why? I cant find difference in Programmer Manual between "between" and "inrange".

The diagrams , FYI.

Hi,

Please check this Thread (http://www.baanboard.com/baanboard/showthread.php?t=28089) and Wiki (http://www.baanboard.com/programmers_manual_baanerp_help_functions_database_handling_sql_and_combined_fields)

Hello,

A simple example to explain this.
You manage a key with 3 parts.
Index1 inrange {a,b,c} and {x,y,z}
All records with first part between a and x, second part b and y and third part c and z are selected.
If abc = 000 and xyz 333, 043 is not selected.
Index1 between {a,b,c} and {x,y,z}
All records with the 3 arts between a,b,c and x,y,z are selected.
043 is selected.

Regards

Hi,

Please check this Thread (http://www.baanboard.com/baanboard/showthread.php?t=28089) and Wiki (http://www.baanboard.com/programmers_manual_baanerp_help_functions_database_handling_sql_and_combined_fields)

Thank you very much!

Hello,

A simple example to explain this.
You manage a key with 3 parts.
Index1 inrange {a,b,c} and {x,y,z}
All records with first part between a and x, second part b and y and third part c and z are selected.
If abc = 000 and xyz 333, 043 is not selected.
Index1 between {a,b,c} and {x,y,z}
All records with the 3 arts between a,b,c and x,y,z are selected.
043 is selected.
Regards

thanks! I am clear!

In fact the "Between" combined a string from the condition field .
like : if between "aaa",0,"AAA" and "ccc",5,"BBB" , so the value "bbb",8,"DDD" is selected. beacuse the string "bbb8DDD" is between "aaa0AAA" and "ccc5BBB". are correct?