Hi Agnes
I know, that's why i always pad the resulting fields in the sql statement, but i found now what was the problem: there was a memo field in the select ( i couldn't see it the first time, since there are many output fields )!
I changed it to be left( thememo ) and it requeries ok now.
Thank you and Sergey too for your prompt help.
Jaime

>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.