Hi!

In general, you will not get a big increase in speed. Compare to the development effort you put into the using of all data in a single view, the speed increase you get is not worth it, my guess.

I do not know exactly what that error means. Also, I suspect that this error is related to the VFP collating sequense that you probably use somewhere in the application to sort data by Denmark alphabetical characters, or you just specify it for ODBC connection when it is not supported by that ODBC driver.



>Hi,
>
>Thanks for your comments on my problems.
>
>My experience with related cursors are, they are slower - but perhaps I'm worng. Therefore I'm using 1 cursor.
>
>Funny enough, I have no problems with the same constitution i local views and VFP db. Only the ODBC is the problem. If I split it up - my guess is that the problem will follow - because it is hte ODBC that has the problem.
>
>If I Update without cursorsetprop (the default values set via wizard) it works without problems. I can (in browsemode) add reccord/edit reccord as wanted - and update. The problem is if you add a reccord - you have to add keyfield field too, if you edit you don't - in that situation you have to gain some control.
>
>In fact all I need to control (programatical) is the specific fields I can update. "simple" ;-)
>
>Perhaps you have an idea here??
>
>(I get error 1526 from the ODBC - collected sequense not supported) and cann't get arround it.
>
>Thanks for your help
>
>Lasse
>
>Thatnks
>
>
>>Hi!
>>
>>I would recomment to do not play with that. My guess that it is more simple from programming and logical point of view to split that cursor to several related cursors.