Re: Search fails, but only for a specific sequence

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

What are the medicines you would expect to find in that range of values? I'm guessing that accented characters specific to German might be causing the result you're seeing.

Assuming that you have an index on Name, do you get the same result using TableDirect access? The reason I ask is that using TableDirect no longer uses the query processor but it does still use the index order.

--
Ginny Caughey
Device Application Development MVP

www.wasteworks.com
Software for Solid Waste Management



"Puddles" <Puddles@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:2295EF7D-6EF7-480F-A838-AFB11C0F2DFF@xxxxxxxxxxxxxxxx
This is weird! My medical database works just fine and has done since ages,
until someone treid to look for a medicin begining with 'ney...'

Major Error 0x8007007A, Minor Error 0
SELECT * FROM t_artikel WHERE NAME LIKE 'ney%'
Der an einen Systemaufruf übergebene Datenbereich ist zu klein.

OK, so it's a German installation, but the issue is not hardware relevant:
same on any Mobile device and on my PC. Varying the search string usually
works, like 'ne%' is OK and 'n_y%' is ok, but 'new%' fails as does 'ney_%'.

Can anyone tell me what is going on here?

Thanks in advance.


.