ODBC AND BIG DATATABLES

John3

Hi,

I have made a ODBC connection between Excel07 and our navision native database (2.60 .

For so far now problems it works great, but....

I have a big datatable (above 500.000 records) when I put a filtre on the primairy key now problem but on other fields it takes a very very long time.

Is there a possibity to select another key on the table (such like setcurrentkey) before we do the datatransfer to excel, because that's the reason it's always sorted by the primairy key.

It would really help a lot !

Thanks for sharing !

kine

Try to use "order by" to enter existing key in NAV which covers filtered fields...

David_Singleton

kine wrote:

Try to use "order by" to enter existing key in NAV which covers filtered fields...

I can't remember off the top of my head, but wasn't that introduced in a later version of C/ODBC

(I may be mixing this up with C/FRONT though).

kine

Do not know, I never used C/ODBC... ;-)

John3

I have tried with "Order by" in the SQL code but he doesn't order it in navision before he takes the data out.