Hi,
I have hit a peculiar scenario with the find statement which cannot be explained.
Scenario:
I have statement with find which i use to find out the ambiguity of a record.
Suppose i have two customers with custnum = 394980 and custnum = 39498091
Now my query reads
Find customer where custnum begins "394980" no-lock.
This should give me an error because it should find two records (as expected).
Now i have two regions one is a test region and other is a local region.
Both of them have the same data.....
It is throwing an error in the test region (which is as expected) but does not in the local region...and i fail to understand why...
Although in my local region if i remove the 0 from the query it starts throwing an error....
Can this be explained ? all your help would be appreciated.
Please note both the regions are in 9.1 E
I have hit a peculiar scenario with the find statement which cannot be explained.
Scenario:
I have statement with find which i use to find out the ambiguity of a record.
Suppose i have two customers with custnum = 394980 and custnum = 39498091
Now my query reads
Find customer where custnum begins "394980" no-lock.
This should give me an error because it should find two records (as expected).
Now i have two regions one is a test region and other is a local region.
Both of them have the same data.....
It is throwing an error in the test region (which is as expected) but does not in the local region...and i fail to understand why...
Although in my local region if i remove the 0 from the query it starts throwing an error....
Can this be explained ? all your help would be appreciated.
Please note both the regions are in 9.1 E