>I'm not using a view it's SQL passthrough
>for example:
>
>SQLEXEC(h,'select * from modacad where recno=220')
>
>I found out that it happens only after the activate then refresh event
>when the form is first built.
>
>If the form is up on the screen and I trigger
>the activate then refresh event no error message occurs.
>
>I just ignored the error in my error handler,
>but I don't understand why...
Are you returning the results to a cursor or just a browse window? You can pass a 3rd parameter which would be the name of a cursor to create and place the results set into.
Mark McCasland
Midlothian, TX USA