>Hello Wim,
Hi Rajan,

>
>so now we meet on the UT after our conversation in Amsterdam. Good to see that you are an active member of this community.
Yes. I think this is THE place for a foxpro developer or consultant to be. The gossip alone is fun already :-).

>
>Thanks for your tip but it is not the solution to my problem. I assumed that the problem had to be -view- related and I therefor decided not to requery the view but to requery the database with the sql-statement of the view into a cursor. This immediately solved my problem but it still makes me wonder why this happened in the first place.

Hmz. Strange indeed. But the behaviour of views has allways been strange in my point of view. We have some views created that cannot be properly modified. It seems the view editor has same problems with complex queries.

>A big bonus is that by redesigning the program with sql has improved the performance and also made it multi-user stable whih it wasn't with the views.

Hehehe, In many occasions this is true. I never use builders and or wizards.

>
>This report has been created with Virtual Print Engine (www.idealsoftware.com). In fact, it is not a report but a program that writes to the print engine. Thinking outside the box can be challenging. If you are using MS-Word for reporting you should take a close look to VPE. It is a engine, trully controleable and extremely fast. It really knows how to handle RTF (unlike MS-Word). My report took > 2 minutes to be created with MS-Word, it now takes 10 seconds with VPE. Making such progress really impresses customers....

Hmm. Looked at it. I've got 1 problem, the 10K user limit. But for the rest it looks promising. I'll look into it. Thnx.
Groetjes,
Wim.