>I have a form that I would like the user to search for records based on any field. It gets trickier. I actually have 3 forms that the user can flip between to search for records based on any field of any form. I tried using the qbf.scx (query-by-form) that is in the samples directory, but it seemed to have its limitations. Parameterized views do exactly what I want, but I'm running into this SQL statement too long problem. I'll be working on it today if you have any suggestions.
>
>Thanks.

I got this error before. I overcame it by making it table buffering in the form and used tableupdate(1,.T.) to force-update. I don't know what is the reason but that is how I do it.

Anyone can tell me why I need to do that? Why wouldn't tableupdate(1,.F.) works when I am running a single user station?