I am getting the following error
:Host variable expected after ':'
:Syntax error: '}' not expected
:Found 2 errors during scanning/parsing .. Stopped.
:Error 302 (SQL syntax not correct on SELECT
:Cannot continue
My program code is attached and the form is a type 3 form. The error occurs when I navigate to the next set of records.

What I find very strange, is that the same code is attached to a different session. Also a type 3 form but different because the data which is displayed is different. When I navigate to the next set of records, I do NOT get this error.

So I think the problem lies in the form but I have compared the two forms and I see nothing to explain this behavior.

Thanks in advance for any assistance.

Maybe a screen shot of the form would help? I agree it sounds like something in the form, but no clue.

In most situations these problems are caused by the query extension. Try to disable the query extension in the script and see if the problem still exists.

Youp

Sorry for the late response. I was off yesterday.

I just did a comparison between the fields in the index and the fields which are displayed on the two forms. On the form that creates the error, I noticed that one of the indexed fields is not displayed on the form.

When I added the field to the form, the form no longer outputs an error message.

Guess I found my own solution. Thanks for the attention.