Hi Bela,

Sorry, but i can't help when you about the question of the creation of cursors.
But, i can give you some ideas to perform your task.

1 - Use indexs on the fields you are using at your WHERE clauses (and JOIN, of course). ALthough VFP creates indexs if necessary, you will get a quicker query if you have indexs already created.

2 - Avoid the "SELECT * FROM ...". Everytime you know the fields you need, use it; don't use SELECT * too many times.

3 - Be carefull with cursors and Public Arrays or variables. As soon you don't need them, release them.

Well, hope you find your answer.

Good luck and have a nice year 2000, without bugs :)

Ricardo