Prev: VO2Ado ( For Robert o other users )and policies for upgrade..
Next: London & SE VOUG Meeting Feb 2010
From: Karl Faller on 3 Feb 2010 15:15
Hi all,

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?

TIA
Karl
From: Karl Faller on 3 Feb 2010 15:32
In additon, some new finds:
one tag, named "Firma" works in cmDBX, but in my App only for the
first search char
another tag, named "Email" works in cmDBX, but ONLY for certain chars,
e.g. "info" is not found, while "h" is, but "ju" is again not.

Karl

>Hi all,
>
>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?
>
>TIA
>Karl
From: Jamal on 3 Feb 2010 17:21
Karl,

I assume you're doing soft seek. Right.

Do the following

Setorder(...) // result checked
self:gotop()
Self:Server:Seek(cKey)

Jamal

"Karl Faller" <k.faller_withoutthat_(a)onlinehome.de> wrote in message
news:63jjm5dqsuv0f9lohtppoto9ubr7sgbdq3(a)4ax.com...
> Hi all,
>
> 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?
>
> TIA
> Karl

From: Karl Faller on 3 Feb 2010 17:29
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: Gerhard Bunzel on 3 Feb 2010 19:44
Hi Karl,

> 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. Did you check that value? Is
MySuchOrder a string or a numeric value?
- Set your order and check that setting with
SELF:Server:OrderInfo(DBOI_NAME) or SELF:Server:OrderInfo(DBOI_NUMBER).


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


 |  Next  |  Last
Pages: 1 2 3
Prev: VO2Ado ( For Robert o other users )and policies for upgrade..
Next: London & SE VOUG Meeting Feb 2010