>Hi Cetin
>
>>I don't know then. It works pretty well for me.
>
>Do you put the CURSORSETPROP() call before or after the SQL PT? Plus is your cursor a pre-existing cursor, created in VFP and then populated using SQL-PT (that is if this is possible)?

It's before. It sets global cursor property for SQLExec().

No it's not an existing cursor, it's an SPT cursor. ie:

lnHandle = SQLSTRINGCONNECT("Driver=SQL server;server=(local);Trusted_connection=yes")
CURSORSETPROP("UseMemoSize",255,0) && this is default if you don't set at all
SQLEXEC(m.lnHandle,"select LastName,FirstName,cast(Notes as char(100)) as Notes"+;
  " from Northwind.dbo.employees","myEmployee")
SQLDISCONNECT(m.lnHandle)
browse

Cetin