Hi Jaime,
this is a common problem with views.

You need to compare the STRUCTURE of the view created with use .. nodata to this created with Params
i.e.

use ... NODATA
DISplay STRUCTURE to file xNoData.txt noco
use
*set your data so that the view is filled (this paras that causes error on REQUERY())
use ...
DISplay STRUCTURE to file xWithData noco
use

modi file xNoData.txt nowait
modi file xWithData.txt nowait

Compare the two files, you will see there is at least one field that differs in structure.

Redesign your view so that it will come to the same structure in each and every case.

Agnes

>That's the first thing i did Sergey. It's unbelievable. Even from the command window, i run the create sql command, and then just USE the view. It asks for params and works. I run the requery right away, and it doesn't work anymore.
>In the meantime, in the Init of the form, i wrote

>*** view params set here ***
>select MyView
>use
>use Myview
>

>It works ok like that, but it's weird.
>
>
>>
>>Do you've any calculated fields in the view, character fields in particular? If you do, use PADR() function to make it the fixed size.