Sometimes YES, sometimes NO

This is my SELECT statament:

Code:

---

SELECT DISTINCT(contrat.rsocial) FROM contrat,contra _
WHERE contrat.rsocial=contra.contrat _
AND contra.centro IN _
(SELECT centro FROM derechos _
WHERE usuario='MyUser')

---

Sometimes returns me values and sometimes returns EMPTY !!!!

I'm using VB6 with VFP as database in WIN98.

Any idea will be deeply appreciated.

Thanks!

Anyone besides you using the database?

Out of curiousity, is there a reason you're still using FoxPro?

The database is a VisualFoxPro 5.0. It is in a Novell Netware 5 server and there is several users in all the WAN accesing to the database.

This never have been presented before in (6 months) all this project.