ADS Troubles

[Janko]

I am using ADS for years an currently I have following versions: Novel 6.5 with ADS 10.10.0.17, client version is 10.10.0.3, WIN10 / 64 bit. Tables are DBFNTX, xBase 20.817 and eXpress 264.

One of them, browsed without ADS connected is positioning cursor (after gotop) to record 1, after ADS connected, gotop is positioning browser to record 7, but can be pushed to record 1.

Other functions, where sam table is used, do not see records from 1-7.

There are no errors reported, ADS is connected via rutine which Roger posted long time ago, architect estabilishes remote/local connection with no troubles. I also copied the DBF / record per record, reindexed, created indexes...... no changes

I Will be greatful for any hint or direction oropinion how to detect the problem.

Kind regards
Janko

[Cliff Wiernik]

Try reindexing the file. That is the only time I have seen this, a corrupted index.

[Janko]

Thanks for the hint, of course, I did it, many times. But no success. With the same index and no ADS, it works OK.
Also VIA architect, index works properly.

BR Janko

[rdonnay]

Upload your database and index.

[Janko]

In attachment: two pictures of the browser, one DBF and one NTX.

Best regards
Janko

[rdonnay]

I see no problem. I tried with ADSDBE and also with DBFNTX.

Both go to record 1 with a dbgotop().

Try testing with XDOT.EXE

XDOT /adsntx

[Janko]

Thank you for your good will.

The same with architect, VIA ADS or directly through DBFNTX, no problem.
But see pictures I sent.

What would you check further if you had that kint of problem?

BR JAnko

[rdonnay]

This is my ADS settings in XDOT for /adsntx:

DbeInfo( COMPONENT_DATA, ADSDBE_TBL_MODE, ADSDBE_NTX )
DbeInfo( COMPONENT_ORDER, ADSDBE_TBL_MODE, ADSDBE_NTX )
DC_AdsIndexModeDefault( ADSDBE_NTX )

My only suggestion now is that you give me a small program that can demonstrate your problem.

[Janko]

I will do so in next days. first I am going to check connecting parameters.

Thank you for your time
Janko

[Janko]

Roger,

preparing a demonstrating program for you I found out that behaviour of DBFNTX and ADSDBE is not same

Code: Select all

001   USE Dobavnice index stev_dob , stev_dob02, stev_dob03, stev_dob04,stev_dob05  NEW   SHARED 
002  dobavnice->(dbgotop())     -------------------> missing line
003  dobavnice->(dbSetOrder(cGroupF))
004  set relation to Dobavnice->partner into PARTZ
005
006  wtf dobavnice->(indexord()), dobavnice->racun PAUSE

Line 002 was not in my code: when table was opende VIA DBFNTX - cursor was moved to first indexed record
when table was opened VIA ADSDBE - cursor was not moved to first indexed record, but stayed on top physical record in natural order. After inserting line 002, behaviour is equal.

I am sorry that I've caused a hurricane in a glass of water. But maybe someone will use my experience and shorten his bug fixing.

Kind regards
Janko