ADS Troubles
ADS Troubles
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
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
-
- Posts: 605
- Joined: Thu Jan 28, 2010 9:11 pm
- Location: Steven Point, Wisconsin USA
- Contact:
Re: ADS Troubles
Try reindexing the file. That is the only time I have seen this, a corrupted index.
Re: ADS Troubles
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
Also VIA architect, index works properly.
BR Janko
Re: ADS Troubles
Upload your database and index.
The eXpress train is coming - and it has more cars.
Re: ADS Troubles
In attachment: two pictures of the browser, one DBF and one NTX.
Best regards
Janko
Best regards
Janko
- Attachments
-
- WinZip Shared File 2017-09-05 04-49.zip
- (363.78 KiB) Downloaded 969 times
Re: ADS Troubles
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
Both go to record 1 with a dbgotop().
Try testing with XDOT.EXE
XDOT /adsntx
The eXpress train is coming - and it has more cars.
Re: ADS Troubles
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
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
Re: ADS Troubles
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.
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.
The eXpress train is coming - and it has more cars.
Re: ADS Troubles
I will do so in next days. first I am going to check connecting parameters.
Thank you for your time
Janko
Thank you for your time
Janko
Re: ADS Troubles
Roger,
preparing a demonstrating program for you I found out that behaviour of DBFNTX and ADSDBE is not same
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
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