SELECT results with NT Service (Networking Products)
At 07 JUN 2001 09:49:15AM Ian Lord wrote:
We have a user who is running AREV 3.12 with All Networks driver and NT Service 1.5 who are having problem with results from SELECTs.
They have a table with keys such as 01014 and 1014 (I know this dosen't make for good practice but they have done it now). When they do a select, no matter how it is formatted only the earliest input record is returned, i.e. either the key with the leading zero or not, but never both. Also only one of the keys is in any of the indexes. we have tried to replicate on our site but we use Novell with the NLM at it works fine, i.e. both records are returned.
Any ideas anyone?
At 07 JUN 2001 10:08AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Is the field in question indexed at one site and not the other?
World Leaders in all things RevSoft
At 08 JUN 2001 03:28AM Ian Lord wrote:
The field is not indexed on either site. It is the key field. The records are not contained in any index on other fields as we have examined the ! files.
At 08 JUN 2001 09:37AM Don Miller - C3 Inc. wrote:
If the field is numeric (and assumingly Right Justified), then a zero-filled field (0001) will evaluate to the same value as 1. So, if your select is SELECT SOMEFILE WITH PROD_NO FROM "0001" TO "0005" and your data has 0001 0002 0003 0004 0005 and 1 2 3 4 5, the results will be, as they say, indeterminate. When I need this, I use the NUM2CHAR_CONV user-defined conversion. This was supplied in AREV 3.x, but am not sure whether it made it to OI. I put it in SYSPROCS in OI.
Don Miller
C3 Inc.