CursorSetProp("FetchSize",-1,0)CursorSetProp() function may look as a vicious circle at first glance. One need to set the cursor property before getting the cursor through SQLExec(). General synthax of CursorSetProp() is
CURSORSETPROP( cProperty [, eExpression] [,cTableAlias | nWorkArea])If you try to set the property of an inexisting cursor, an error is generated. The trick is to use 0 as nWorkArea. If the function sets the property of work area 0 (which actually does not exist), all future cursors will "inherit" this value. In other words, set the property once and it becomes default. The same trick is true for SQLSetProp(), when you don't have a connection handle yet.
>SQLResult = sqlexec(h, "select * from MySQLTable", "MyCursor") >do while SQLResult == 0 > SQLResult = sqlexec(h) >enddo >>