Hi Vlad,

Actually I meant parameter and wrote variable. It's a variable in the program that defines it. It uses the "?" in the syntax. I found the answer though; had to set the value of SSNSRCH in the command window before the view could be saved or viewed.

Renoir


>Hi!
>
>It is very rare situation when variabe is used in the view. Usually view is created with parameters, that means each variable is prefixed by "?" and variables with the same names and values for view parameters require to be prepared each time before view opening or requery() command running.
>
>HTH.
>
>>I'm using ViewEdit and getting an error when modifying a view created in the View Designer. The error is "Error in SQL: Error number 1806 SQL: Column "SSNSRCH" is not found." SSNSRCH is a public variable used in the filter portion of the View Designer. Does anyone know if this app does not support the use of variables in the SQL? If it's done under the "Build field list" button then I would additionally like to know under what condition the button becomes enabled, as it is not available to me. Thanks!
>>
>>Regards, Renoir