Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best Practices in Fetching Recs for a C/S DataEntry Form
Message
From
23/07/2010 20:46:43
 
 
To
23/07/2010 07:45:36
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MySQL
Miscellaneous
Thread ID:
01473556
Message ID:
01473665
Views:
118
Thomas,
	liRecords = 200
	liStatus = 0
	lcCursor = SYS( 2015 )
	lcSqlSelect = [select * from mytable]
	CURSORSETPROP( [FetchAsNeeded] , .T. , 0 )
	IF liRecords > 0
		CURSORSETPROP( [FetchSize] , 200 , 0 )
	ENDIF 
	DO WHILE ! USED( lcCursor ) AND liStatus >= 0 
		liStatus = SQLEXEC( giConnectIDAsync, lcSqlSelect , lcCursor )
	ENDDO
	CURSORSETPROP( [FetchAsNeeded] , .F. , 0 )
In your code, you used SQLEXEC(). Does this mean CursorFill() does not work hand in hand with the Fetch* properties?

Thanks
Dennis
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform