From: Dave Francis on
Karl,

You go go-go and I go ga-ga - what a pair! :o)

But I have never had this problem just in VO. If cmVODBX can find records,
it sounds like the index is ok. In this case, I would do a Safe Copy in
cmVODBX and see if the problem persists. Then I'd change that key to
something like Firma+'' , just in case that catches the problem. When you
find the culprit, you'd best send a bad example to Robert, so he can at
least define the circumstances that this can happen in.

Good Luck,

Dave
"Karl Faller" <k.faller_withoutthat_(a)onlinehome.de> wrote in message
news:qfemm558en0293b9u2fvaqq7pan2ae77i8(a)4ax.com...
> Dave.
> to preclude cmVODBX, i removed the whole CDX file and rebuilt it in
> the app, but the problem persists. At least i'm happy you know my
> problem - had started to think i'm completly gone go-go ;-)
>
> Karl
>>
>>I have seen the same problem (though it varies with different versions of
>>cmVODBX). However I set oemansi/collation, I find the indexes are
>>inconsistent. We have a rule now that we never use cmVODBX to create
>>indexes - it does not often go wrong, but when it does it takes an age to
>>sort out because you do not expect such an elementary problem. If we
>>create
>>the index in the app we use the index in, there is never a problem for us.
>>It may even be some sort of dll hell here, who can say?
>>
>>There must be a relatively simple logical explanation for this, but it
>>happens so infrequently, I have stopped looking for it.
>>
>>HTH
>>
>>Dave Francis
>>
>>
>>"Karl Faller" <k.faller_withoutthat_(a)onlinehome.de> wrote in message
>>news:uqukm55set6f6cbsa43mgejh2thnth0ki0(a)4ax.com...
>>> Hi Gerhard,
>>>>> Default( @lSoftie, FALSE )
>>>>> OldOrder:= SELF: Server: INDEXORD()
>>>>> IF ! SELF: Server : SetOrder( MySuchOrder ) // 2/10 KF
>>>>> Meldung("Error", "Suchorder konnte nicht gesetzt werden!")
>>>>> ENDIF
>>>>
>>>>- 'MySuchOrder' is not defined in your code.
>>> some lines above it is, that's the problem with stripping down code
>>> ;-)
>>>
>>>> Did you check that value?
>>> Yes - can see it in the debugger set
>>>> Is
>>>>MySuchOrder a string or a numeric value?
>>> String, the Orderexp is simply "Firma", i.e., build by the value of
>>> Field "Firma". My Seek expr is "Hi", so also no chance for any
>>> Ansi/OEM mismatch, i think.
>>>
>>>>- Set your order and check that setting with
>>>>SELF:Server:OrderInfo(DBOI_NAME) or SELF:Server:OrderInfo(DBOI_NUMBER).
>>> s.a.
>>>
>>> Karl
>>>
>>>
>>>>
>>>>HTH
>>>>
>>>>Gerhard
>>>>
>>>>
>>>>
>>>>
>>>>"Karl Faller" <k.faller_withoutthat_(a)onlinehome.de> schrieb im
>>>>Newsbeitrag
>>>>news:kttjm5d4g3r34tjnva9phk7jfqe3nmf2dn(a)4ax.com...
>>>>> Jamal
>>>>>
>>>>>>I assume you're doing soft seek. Right.
>>>>> No
>>>>>
>>>>>>Do the following
>>>>>>
>>>>>>Setorder(...) // result checked
>>>>>>self:gotop()
>>>>>>Self:Server:Seek(cKey)
>>>>> Sorry, but no go. These is the actual code...
>>>>> METHOD SuchNachDBObjekt ( MyKey, lSoftie ) CLASS dtaWinBase
>>>>> ... // some locals...
>>>>> Default( @lSoftie, FALSE )
>>>>> OldOrder:= SELF: Server: INDEXORD()
>>>>> IF ! SELF: Server : SetOrder( MySuchOrder ) // 2/10 KF
>>>>> Meldung("Error", "Suchorder konnte nicht gesetzt werden!")
>>>>> ENDIF
>>>>>
>>>>> SELF: GoTop()
>>>>> IF Empty( MyKey )
>>>>> NewRec := SELF: Server: RecNo
>>>>> lSuccess := TRUE
>>>>> ELSE
>>>>> IF SELF: Server: Seek( MyKey, lSoftie )
>>>>>
>>>>> Thx anyway
>>>>> Karl
>>>>
>>


From: Robert van der Hulst on
Hi Karl,
On Wed, 03 Feb 2010, at 21:15:21 [GMT +0100] (which was 21:15 where I live)
you wrote about: 'Order anomaly?'

> a simple DBF, CDX, FPT, some 100 records, some 20 ordertags, these
> mostly build by the field content

> The app uses some generic Search window, but finally it boils down to:

> Setorder(...) // result checked
> If Self:Server:Seek(cKey)
> ....

> The thing what drives me crazy: there's three ordertags, which seek
> correctly one letter, e.g. "h", but fails to find "hi", while:
> * The record is there
> * The order is set correctly
> * cmDBX, using the same data, succeeds
> * to be sure, i removed the whole cdx file and built it anew, but no
> go

> all other tags work, regardless if i seek one char or 10

> I'm rather sure i saw that already some time ago, so i doubt it has
> anything to do with Vo-Versions...

> Anyone seen this or has an idea?

Different settings for:
- SetCollation() ?
- SetNatDLL() ?
--
Robert van der Hulst
AKA Mr. Data
Vo2Jet & Vo2Ado Support
VO & Vulcan.NET Development Team
www.heliks.nl

From: Karl Faller on
Robert,

Meth Start Class App
.....
SetNatDLL( "C:\CAVO2836\Nations\German.dll")
SetCollation( #CLIPPER )
....
that is the only occurence of these settings in the app and associated
libs

Karl
From: Karl Faller on
>Robert,
>
>Meth Start Class App
>....
>SetNatDLL( "C:\CAVO2836\Nations\German.dll")
>SetCollation( #CLIPPER )
>...
>that is the only occurence of these settings in the app and associated
>libs

found the culprit - as usual between chair and keyboard.
The call to the search window had an innocent line, setting the param
for case-indenpendent search set - but the problem order had no
Upper(...

<Arghhhhh>

Sorry for the trouble
Karl
From: Marc Verkade [Marti] on
Hahahahaha... Lesson 1 on 'How to master indexes'... ;-)

Regards, Marc

"Karl Faller" <k.faller_withoutthat_(a)onlinehome.de> schreef in bericht
news:fdp0n5tunjhmjr9m436m5r5s98hq6rhrje(a)4ax.com...
>>Robert,
>>
>>Meth Start Class App
>>....
>>SetNatDLL( "C:\CAVO2836\Nations\German.dll")
>>SetCollation( #CLIPPER )
>>...
>>that is the only occurence of these settings in the app and associated
>>libs
>
> found the culprit - as usual between chair and keyboard.
> The call to the search window had an innocent line, setting the param
> for case-indenpendent search set - but the problem order had no
> Upper(...
>
> <Arghhhhh>
>
> Sorry for the trouble
> Karl