How to use NDX files

[volker...@de.abb.com]

Hello together,

I have an old Clipper application which I compiled with Harbour in order to make it executable on x64 machines. Now we want also to modify the data using Access. Unfortunately, Access supports no NTX, but NDX files. How can I use NDX in my Harbour application?

Thanks! Volker

[GeoffD]

Hi Volker

I may be able to help.

the basic thing to do is REQUEST DBFNDX and then RddSetDefault("DBFNDX") 

before you start opening files

this will be a global setting meaning that individual calls to open data files won't have to be modified

this is the Harbour Help documentation which is searchable for all commands and functions

https://harbour.github.io/doc/index.html 

Hope this helps

Geoff

[W.]

NDX is very old index format, it wasn't available in latest Clipper 5.3 series, it's not supported by Harbour either.

Personally I would do it in a more modern way, like a OLE control written in Harbour which exposes methods to Access that makes writes to your DBF/NTX files. It's also possible to have DBFs located on another computer and make network access using Harbour.

w.

[Alain Aupeix]

Le 27/01/2018 à 10:03, W. a écrit :
> NDX is very old index format, it wasn't available in latest Clipper
> 5.3 series,

Yes

> it's not supported by Harbour either.

False !!!

I continue to use it with harbour 3.2 (last rev)

> Personally I would do it in a more modern way, like a OLE control
> written in Harbour which exposes methods to Access that makes writes
> to your DBF/NTX files.

For windows users only ...

> It's also possible to have DBFs located on another computer and make
> network access using Harbour.

Obviously ...

A+
--
------------------------------------------------------------------------
Alain Aupeix
http://jujuland.pagesperso-orange.fr/
http://pissobi-lacassagne.pagesperso-orange.fr/
------------------------------------------------------------------------
U.buntu 12.04 & Xu.buntu 16.04 | G.ramps 3.4.9-1 | H.arbour 3.2.0dev
(2018-01-05 14:38) | Hw.Gui (2637)
------------------------------------------------------------------------

[W.]

W dniu sobota, 27 stycznia 2018 10:29:56 UTC+1 użytkownik Alain Aupeix napisał:

Le 27/01/2018 à 10:03, W. a écrit :
> NDX is very old index format, it wasn't available in latest Clipper
> 5.3 series,
Yes
> it's not supported by Harbour either.
False !!!

What is false? You're mistaking with NSX, NTX or what?

NDX is not there.

 

I continue to use it with harbour 3.2 (last rev)
> Personally I would do it in a more modern way, like a OLE control
> written in Harbour which exposes methods to Access that makes writes
> to your DBF/NTX files.
For windows users only ...

Access is what was in original question, so that's Windows interest for sure(?)

 

[Alain Aupeix]

Le 27/01/2018 à 10:52, W. a écrit :
>
>
> W dniu sobota, 27 stycznia 2018 10:29:56 UTC+1 użytkownik Alain Aupeix
> napisał:
>
> Le 27/01/2018 à 10:03, W. a écrit :
> > NDX is very old index format, it wasn't available in latest Clipper
> > 5.3 series,
> Yes
> > it's not supported by Harbour either.
> False !!!
>
>
> What is false? You're mistaking with NSX, NTX or what?
> NDX is not there.

Well, ok, I was wrong, and I thought of ntx

Sorry

[Andrzej P. Wozniak]

From: <volker...@de.abb.com>
Sent: Friday, January 26, 2018 10:01 PM

> data using Access. Unfortunately, Access supports no NTX, but NDX
> files. How can I use NDX in my Harbour application?

What about moving from DBT/NDX to FPT/CDX (Foxpro)?
https://docs.microsoft.com/en-us/sql/odbc/microsoft/querying-and-updating-visual-foxpro-data-from-microsoft-access
https://social.msdn.microsoft.com/Forums/en-US/e78f4848-958f-42cc-b834-572fc6c68111/connecting-to-a-visual-fox-pro-database-through-microsoft-access?forum=visualfoxprogeneral
https://support.microsoft.com/en-sg/help/824264/you-cannot-connect-directly-to-foxpro-databases-in-access-2007-and-in

--
Regards from Poland
Andrzej P. Woźniak



- - - - - - - - - - - - - - - - - - - -
D o b r e k o n t o n a T w o j a s t r o n e 40 PLN / rok - k l a t k a . p l