Sometimes YES, sometimes NO

[Tonatiuh]

This is my SELECT statament:


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!

[JHausmann]

Anyone besides you using the database?

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

[Tonatiuh]

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.