Hi Mark

I have a huge problem. The CA property "FetchSize" with a default of 100 exists in the CA. I have tried setting this as in the Help file to -1 but it has NO effect on the fetch speed. The data still comes down in lots of 100.

I have tested this on a local SQL table with > 50 000 records. My select will bring down about 2800 records for a report.

When I run this cursor from a test form, I can see in the status bar rge number of records incrementing in 100 lots whatever I change the FetchSize to. This also happens with SPT.

My code for the spt is similar to that in the CA:
oConn=sqlstringconnect([Driver={Sql Server};Server=localhost;Database=zest;Int Security;])

csql= "select * from client where LEFT(clientno,3) = 'QJI'"
?SQLEXEC(oconn,csql,"myc")

returns the cursor but in lots of 100.

I tried issueing:

CURSORSETPROP("FetchSize" ,-1)
and
CURSORSETPROP("FetchSize" ,3000)

and even
CURSORSETPROP("FetchSize" ,-1,0)

but I still get the data down in lots of 100. I have even SET RESOURCE OFF, changed the Options/RemoteData to select ALL and even tried Syncronous/asyncronous mode with the same result.

I have tried this code on my work as well as home computer with the same result, both using XP and VFP8SP1.

My SQLODBC driver is v2000.85.1022.00 dated 20/02/2003

I am literally pulling my hair out in frustration as I cannot for the life of me find a way of getting the data down in one lot :(

Even the MS Sample form in samples/solution/toledo/casample.scx displays the same behaviour.

Please help as I am in the middle of a VFP>SQL2000 conversion and have based my dataaccess on CA's and SPT, both of which refuse to heed the FetchSize Property.

Also I have found a way to get the CA's to work with transactions by setting the = SQLSETPROP(gnHandle, 'Transactions', 2), doing all my updates, doing a SQLCOMMIT or SQLROLLBACK (if failed) and finally
= SQLSETPROP(gnHandle, 'Transactions', 1). I have tested this and it works.
(this was a query I had addressed to you)

Any help with my problem would be much appreciated.

TIA

Bernard

ps. Glad I could be of help with the CABuilder and views.
pps. Is it possible that you have the CA builder as a FORm rather than a prg as I have some ideas and find it difficult to edit objects in a prg.:)




TIA

Bernard