My guess is you have your Asynchronous and/or BatchMode properties set wrong. Use SQLGETPROP() to determine what these settings are. Asynchronous should be FALSE, and BatchMode should be TRUE. These props can be set globally before you open any views --
SQLSETPROP(0, 'Asynchronous', .F.)
SQLSETPROP(0, 'BatchMode', .T.)
>Mark
>
>I've managed to get the Oracle driver working, but the problem that I have is refreshing a remote view that's linked to the Oracle database. I have to insert a pause, directly before the refresh() command, to give the view enough time to update. If I omit the pause, or the pause isn't long enough, I either get an error message, or I'll only have a sub-section of the results. I've currently got the pause at 5 seconds, and this will return around 1000 Oracle results. Surely I'm not supposed to keep do it in this way?
>
>Regards
>
>Derek
Mark McCasland
Midlothian, TX USA