ODBC connection with Limitation

Asallai

Hi All,

I've search this topic, but cannot find it.
My question is: I try to import to Borland Delphi (but this is not interesting) from navision via ODBC connection, but I have many tables with many (!) records! I know the PSQL is contains a Limit command, what is set the limit of the record for the import.

This is PostgreSQL:

LIMIT and OFFSET allow you to retrieve just a portion of the rows that are generated by the rest of the query:

SELECT select_list
FROM table_expression
[LIMIT { number | ALL }] [OFFSET number]

If a limit count is given, no more than that many rows will be returned (but possibly less, if the query itself yields less rows). LIMIT ALL is the same as omitting the LIMIT clause.

Source:
http://pgsqld.active-venture.com/queries-limit.html

The problem is, when I'd like to make connection to the database the OP System is show me up : "Not enough Virtual memory...", because the table is too large.
Can I set the maximum limit of the import procedure? :?:

If anyone can help. please do it! Thank you!

A

Administrator

[Topic moved from Navision Tips & Tricks to Navision forum]