Data Environment & Serverside Cursor (CURSE!!!!)

[jmcbride]

I have a Data Environment setup with a connection to a database. I use an sql command to select a set of records. into a MSHFlexGrid. <br><br>The Properties of the command under the Advanced option have been set to static cursor, and that it should use a serve-side cursor. <br><br>When I run my program the select statement only comes back with 106 records instead of all records.<br><br>If I change the properties to use a client-side cursor the select statement pulls back all the required records!<br><br>By using the client-side cursor option I can at least get round the problem<br><br>But I still need to find out why the server-side option does not work properly<br><br>Anyone got any ideas on how to overcome the&nbsp;&nbsp;the curse of the server-side cursor?!!!!!<br><br>