>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)
SQLEXEC(m.lnHandle,"select LastName,FirstName,cast(Notes as char(100)) as Notes"+;
" from Northwind.dbo.employees","myEmployee")
SQLDISCONNECT(m.lnHandle)
browse
Cetin