Hi!
As far as I know, view could not have any other buffering but 3-d (optimistic row) or 5-th (optimistic table).
>I am using SQLEXEC to get the data from a SQL Server and I found out that the returned cursor (according to VFP doc) is set to ROW_OPTIMISTIC_BUFFERING mode and I cannot remove it in any way.
>
>This sort of behaviour is only happens with views and I am not sure whay with the results of a SQLEXEC?
>
>Does anybody know how to remove the buffering?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.