dbsetprop fetchsize not running even set to -1

[dickylam]

I have a table in sql database's table which contains around 31,000 rows (records).

I use SQL passthrough method to access the table and use SQLVIEW to load all records.

create sql view temp_view remote connection zodbcname as "select * from ztable"

select 0
use temp_view

= dbsetprop('&zclaritylist_view','view','fetchsize',-1)

However, only 1,100 records returned.

I checked the maxrecords is also -1 (which is all results).

I do not know really what happen is it and I feel better I use ado API to read record.

Please advise.

 

[Mike Lewis]

Dickylam,

What back end are you using? If it is SQL Server, check its ROWCOUNT property.

Also try running the same query using SQL Pass-Through:

lnConn = SQLCONNECT("zodbcname&quot
SQLEXEC(lnConn,"SELECT * FROM ztable","temp_cursor&quot
SELECT temp_cursor
BROWSE


If that doesn't solve it, try sending this:

SQLEXEC(lnConn,"SET ROWCOUNT 0&quot

Do that just before the other SQLEXEC() above.

Let us know the result.

Also, be aware that the process will take a long time. You will see the Browse straight away, but it might take many seconds for the last record to come across.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[dickylam]

Thank You.

I use the first method. But I would like to know the cursor return will be a table or remote view ?

If it is a table, will it create under the current opened databse ? If I do not create under the current opened databse, how can I do ?

Thanks.

 

[wgcs]

The result of the SQLEXEC command will be a temporary cursor.

It will not belong to the current database, but unlike a free table it will support long field names.

it may show up in the GETENV("TEMP&quot directory with a random filename, but as soon as the cursor is closed (with "USE&quot the temp file will go away.

 

[dickylam]

Thank You.

I will use the first method to replace my existing SQL Remote View calling.

 

[Mike Lewis]

Dickylam,

Let us know if it works.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[dickylam]

Mikelewis

Yes, It works. Thanks.